I need Increase/Decrease/Equal/NA fields to calculate in formula... HELP

[CNNNN]

I am having trouble with an excel formula.

I have multiple fields and the formula I enter is not working.

=IF(B7>F7,"Increase",IF(B7<F7,"Decrease",IF(B7=F7,"Equal",OR,"NA")))

I need it to be:
if B7 is a larger number than F7, it comes up as increase

If B7 is a smaller number than F7, it comes up as Decrease

If B7 is the same as F7 it comes up as Equal

but if the field is empty I need to to say NA ... and it keeps showing as Equal.

Why/ Whats the correst formula?

Thank you,

[Ace_XL]

=IF(B7>F7,"Increase",IF(B7<F7,"Decrease",IF(AND(B7="",F7=""),"NA",IF(B7=F7,"Equal",""))))

[Richard Buttrey]

Hi,

One way, probably amongst several

Please Login or Register  to view this content.

[CNNNN]

=IF(B9>G9,"Increase",IF(B9<G9,"Decrease",IF(AND(B9="",G9=""),"NA",IF(B9=G9,"Equal",""))))

The above formulas work, except for when B9 has a number and G9 is blank. Then it is counting the blank Cell as a value of 0 and calculating and "increase" in the cell.

How do I enter the formula to say
B9>G9 - increase
B9<G9 - decrease
B9=G9- Equal
B9 and G9 cell are empty - NA
one or the other of B9 or G9 are empty - NA

[Ace_XL]

Richard's formula will do it..