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
|