Hi,

excel 97.

I'm trying to use a logic command to call up a < sign depending on whether a result in one cell when subtracted from another gives me a negative value.

=IF(B2="AD1", ((E2-$D$23)<$D$25,"<", " "), OR (B2="AD2", (E2-$F$23)<$F$25,"<", " "))

The above formula gives me an error message, is it possible to do what i'm trying to do?

TIA

G