If this and this, then do a) b) or c)

[Guest]

I want to make an if stament that says if something is this and this, do
option a, if its this and this do option b, and if neither do c

Kinda like an else if.

Is this possible in excel?

 

[Dav]

Yes you need to combine IF and AND statements

=if(and(a1>0,b1>0),c1,if(and(a2>0,b2>0),c2,c3))

in the above example
if a1 >0 and b1>0 return c1
else if a2>0 and b2>0 return c2
otherwise return c3

Regards

Dav

 

[Guest]

=if(AND(condition1,condition2),do1,IF(AND(condition3,conditon4),do2,do3))

HTH

 

[Guest]

That you very much, both of you.