On Jun 14, 12:14 pm, Ola2B wrote:
On 14 Jun, 16:42, 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.

In cell E38, the amount is -£50,000 and in cell E39, the amount is +
£50,000. Basically these are variances which i expect a triger. And
that is any variance over and above this amounts should alert me.

Besides, many thanks for all those that have responded so far and will
try all the different suggestions in few minutes.

Ola.

You're not referencing E39 in your example. I'm guessing that's a
typo.

By "over and above" -£50,000 I assume you mean something like -
£55,000. So that you're looking for figures that are greater than
£50,000 or less than -£50,000. Or to put it another way, figures not
between -£50,000 and £50,000.

Try this:

=IF(OR(N15<$E$38,N15$E$39),"INVESTIGATE","FINE")

Mark Lincoln