Ola

It sounds like you should be able to do this with an =IF(OR..formula, but
your logic appears wrong
The only condition NOT matched by your stated criteria is if C4 is less
than -50,000.
In other words, the "+50,000 bit" isn't doing anything as it is already
covered by "-50,000)
You probably need something like:
=IF(OR(C4=E38,C4<=E39),"INVESTIGATE","Fine")
With different numbers in E38,E39 (-50000 and 50000 ?)

Clarification needed, I think.

Regards, Phil



"Ola2B" wrote in message
oups.com...
I need a formular that will give "investigate" in a column when a
amount in cell c4 equal to -£50,000 or greater or +£50,000 or greater.
Iam currently using this =IF(N15$E$38,"INVESTIGATE",IF(N15<$E
$38,"fine",FALSE)) which doesn't seem to be working.


Many thanks,
Ola.