In that case, following on from my earlier suggestion,
=IF(OR(C4=$E$38,C4<=-$E$38),"INVESTIGATE","fine")
or more simply =IF(ABS(C4)=$E$38,"INVESTIGATE","fine")
--
David Biddulph

On Jun 14, 5:54 pm, Ola2B wrote:

You're correct! i think i probably confused myself more that anyone so
far. Let us for now ignore cell n15. I have a variance cell i.e. c4,
now if this cell shows a negative or a positive amount of £50,000 or
more i want the result cell, i.e. cell c5 to come up with
"investigation" otherwise "fine".

What this means is that where the variance in cell c4 is, for example
is +£49,000 or -£49,000, i expect a "fine" result. I hope this
clarifies my request and apologies for earlier confusion.


On 14 Jun, 17:37, "David Biddulph" <groups [at] biddulph.org.uk
wrote:

First point: You asked for something looking at an amount in cell C4, but
your formula looks at N15 and E38. I assume that your £50000 is stored in
E38? Perhaps you can check whether you are looking at C4 or N15?

Second point: Your formula will return FALSE if N15 is equal to E38. I
don't think this is what you intended.

Third point: You talked about "equal to -£50,000 or greater or +£50,000 or
greater". Do you mean less than -£50000 or greater than +£50000? You don't
seem to have tested the negative limit, so perhaps
=IF(OR(N15=$E$38,N15<=-$E$38),"INVESTIGATE","fine")

Fourth point: You gave us the not desperately enlightening information that
it "doesn't seem to be working". It is easier for folk to help you if you
give them a report of what error messages, if any you are seeing, what
result the formula is giving for what input, and what result you expected to
see. There are some clairvoyants on the group, but their crystal balls work
better with some information.

Fifth point: If you are still getting unexpected results, it might be worth
checking that the relevant cells do contain numbers, and not text that looks
like numbers. Try =ISNUMBER(N15) and =ISTEXT(N15) and similarly for E38.
Spaces & non-printing characters can sometimes confuse you.

"Ola2B" wrote in message

roups.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.