AND IF STATEMENT

[Sam Hamman]

Hi I would like to do the following but have no idea what the format
of the formula should be so any help appreciated:

=IF(AND(EP86426="Standard",AA86426>0),1,0)

So I want cell EP86426 to contain the word standard and I want the
cell AA86426 (which in itself has a formula which returns 1 or 0) to
be greater than 0. this part of the formula works but I also want to
look at cell CK86426 and if its value is greater than zero I want it
to return a 1 in cell AB86426

I hope that is clearly explained lol

Thanks in advance

Sam

 

[joeu2004]

Hi I would like to do the following [....]
=IF(AND(EP86426="Standard",AA86426>0),1,0)

So I want cell EP86426 to contain the word standard and I want the
cell AA86426 (which in itself has a formula which returns 1 or 0) to
be greater than 0. this part of the formula works but I also want to
look at cell CK86426 and if its value is greater than zero I want it
to return a 1 in cell AB86426

(I assume the formula above is in AB86426.)

Well, you're 2/3 of the way there. If you look at the help page for the AND
function, you will see that it can have more than 2 parameters. AND()
returns true only if __all__ of its parameters (conditions) return true.
So:

=IF(AND(EP86426="Standard",AA86426>0,CK86426>0),1,0)

If that does not do what you intend, please provide examples of values in
EP86426, AA86426 and CK86426 for which you want this formula to return 1 and
0. (There are at least 8 possible examples.)