Help with fixing formula
 

=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

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

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

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" wrote in message
...
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

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

"Pat" wrote in message
...
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" wrote in message
...
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