Percentage
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1

Percentage
 

If the percentages are in Cell A1 and A2

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

"chedd via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1

Percentage
 

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



"chedd via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1