Hi Pat

maybe if you outlined the data you have, the criteria you want and the
outcome (maybe with a few examples typed out) i'm sure a workable formula
can be found.

Cheers
JulieD

"Pat" wrote in message
...
Hello JulieD,

I have made the assumption that =2 of the formula would refer to the value
2 in A. However the formula as it stands does not give me the result I am
looking for. I have played around with the formula but could not get
anywhere, can you help?

Pat


"JulieD" wrote in message
...
Hi Pat

how about
=IF(AND(ISNUMBER(Z32),(Z32<0),A32*A32=2),"Load"," ")

Cheers
JulieD

"Pat" wrote in message
...

=IF(ISNUMBER(Z32)*(Z32<0),"Load","")

The above formula works fine but I want to introduce and additional
criteria as follows:

=IF(ISNUMBER(Z32)*(Z32<0,(A32)*(A32)=2)),"Load"," ")

this modification is obviously not correct, does anyone know what is
missing?

Many thanks if you can help out.
Pat