What values are in N15 & E38? You only appear to have one test for the
INVESTIGATE situation.

Do you want to test the absolute value (Ignoring sign)?

=IF(ABS(N15)$E$38,"INVESTIGATE","fine",)

where E38 = 50,000, N15 =value being compared





"Ola2B" wrote:

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.