View Single Post
  #5   Report Post  
Frank Kabel
 
Posts: n/a
Default

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Pat" schrieb im Newsbeitrag
...

=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