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
Bookmarks