Percentage

[chedd via OfficeKB.com]

I wish to make a comparision between one month percentage to another and show
the difference to state whether it is higher or lower. Is there a formula
that could do this.

 

[Guest]

If the percentages are in Cell A1 and A2

use the folliwing formula : =if(A2>A1,"Higher";IF(A2<A1,"Lower","Equal")

 

[Guest]

If you have a list of percentages in column A, then this in B1, copied down,
will provide a graphical sort of visual.......

=REPT("*",A1*100)

Vaya con Dios,
Chuck, CABGx3