Help with fixing formula

[Pat]

=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

 

[JulieD]

Hi Pat

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

Cheers
JulieD

 

[Frank Kabel]

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

 

[Pat]

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]

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