=IF(B9'Apr 06 monthly report'!B9,"Higher",IF(B9<'Apr 06 monthly
report'!B9,"Lower","Equal")).

This formula works fine, just as it's supposed to. The problem appears to
be in your smaller formula, whereas "0%" is actually TEXT, not the number 0%
and the two are not the same.....try this instead anf format the cell for
Percentage if desired.

=IF(C9=0,0,C9/B9)

Vaya con Dios,
Chuck, CABGx3







"chedd via OfficeKB.com" wrote:

Hi

I am using this formula to show in a report the difference in total
percentage between two months =IF(B9'Apr 06 monthly report'!B9,"Higher",IF
(B9<'Apr 06 monthly report'!B9,"Lower","Equal")). This works fine until in
cell B and C are the same value i.e. 1 and 1. therefore in cell D it shows
100% creating cell E Higher value statement instead of equal. I have no
issues to when 0 is shown in cell B and C as this displayed as Equal. The
formula to show the percentage value is =IF(C9=0,"0%",C9/B9). Can anyone
help

--
Message posted via http://www.officekb.com