Help with fixing formula

  • Thread starter Thread starter Pat
  • Start date Start date
P

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
 
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
 
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
 
Back
Top