M
MikeM
Is there a way to combine the "IF" function and the "AND" function in one
formula?
formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=if(and(a1=5,b1="yes"),"both are true","at least one is not true")
K
Kevin B
The following conditions is IF A1 = 12 and B10 = 15 and C2 = 0 then condition
is met, otherwise it's not met.
=IF(AND(A1=12,B10=15,C22=0),"Condition Met", "Condition Not Met")
is met, otherwise it's not met.
=IF(AND(A1=12,B10=15,C22=0),"Condition Met", "Condition Not Met")
M
MikeM
I want to return a value from another cell as opposed to a "true" or "false",
is this possible?
MikeM
is this possible?
MikeM
K
Kevin B
Just replace the text values with the cell you want referenced:
=IF(AND(A1=12,B10=15,C22=0),Z10, X11)
=IF(AND(A1=12,B10=15,C22=0),Z10, X11)
M
MikeM
Thanks for your help!
MikeM said:I want to return a value from another cell as opposed to a "true" or "false",
is this possible?
MikeM