Purchase Order Percentage

[Indranee]

Hai,

Referring to the attached excel file. I minus the date distribute and prf received time column and the number of days will appear. Next to the number of days column is percentage column.

In the percentage column I put formula as "=if(Q3<4,"100%")"

if the Q3 more than 4 days I want the percentage to appear between 99% to 0%.

How to get the formula.

Please help me on this.

Thanks in advance

Regards,
Indranee

 

[PCosta87]

Hi,

How do you calculate the percentage when >4 days?
If you only wish to show "0-99%" you just need to complete the formula you already have:

"=IF(Q3<4,"100%","0-99%")"

100% if condition is true (Q3<4)
0-99% if condition is false (Q3>=4)

Hope this helps

 

[vletm]

If You would really like to see value with PERCENTS then write 100%;
not "100%"
other part ... between 99% to 0% ... ex. You could use RAND()*0.99
if no rules how to get that value.
=IF(Q3<4,100%,RAND()*0.99)

 

[Indranee]

Hi,

Just now I tried I cannot get it with the both answer.

Please use the file I attached. Then I can see how to get it

Thanks

 

[vletm]

I used ... here You go!

 

[PCosta87]

Hi,

Just now I tried I cannot get it with the both answer.

Please use the file I attached. Then I can see how to get it

Thanks

I've added both mine and @vletm solutions to the attached file.
Please take a look at it

 

[Indranee]

No. Actually I want like this Q3<4=100% and Q3>4=99% to 0%

Means if date distribute minus prf received date is = 6 days

I want the percentage to drop to 95% or 90%

Please help me.

Thanks

Indranee

 

[vletm]

Please, if You write this and think that ... You would get this!
Rand worked ... test, if this would be that now or make minor modify.

 

[Indranee]

Yes. Thank you.

Can I ask you how u get this =IF(Q72<4,100%,1-(Q72-4)/50)
1-(Q72-4)/50) what meaning of this.

 

[vletm]

if You would like to get %s then You should do something like that!
You should know some kind of MAX (now 50) value. Use which needed.
Q72-4 makes that 1st step.
1- something shows (100% - value) makes less than 100%

 

[Indranee]

Hai Vletm,

Thank you very much for help.

Indranee

 

[Indranee]

Hai Vletm,

I want to do a pie chart. From the column no of days and done by column. That is like within 4 days, more than 4 days and etc.

Please help.

Thanks.

 

[vletm]

Did You tried to do it?

 

[Indranee]

Yes, I tried. But with normal table and chart not with pivot table.

 

[Indranee]

Hai,

I have attached a file. In the cell colored yellow i want percentage. Please see the table and help me.

Thanks.

 

[vletm]

Different colors?

 

[Indranee]

Thank you. I like your answer.