Help with fixing formula

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
 
P

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
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(ISNUMBER question 0
IF and ISBLANK functions 2
IF and ISBLANK functions 1
IF and ISBLANK Functions 1
IF and ISBLNAK functions 2
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Return result from multiple criteria 6
Search for specific number in a range 1

Top