View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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