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.

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

[hans bal(nl)]

If the percentages are in Cell A1 and A2

use the folliwing formula : =if(A2>A1,"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
>

[CLR]

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
>