Maybe if you explain what you want to do, then we could help. What you are
doing does not look possible by just looking at the formula.

Mangesh



"G_Chem" wrote in
message ...

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


--
G_Chem
------------------------------------------------------------------------
G_Chem's Profile:
http://www.excelforum.com/member.php...o&userid=24366
View this thread: http://www.excelforum.com/showthread...hreadid=474095