Just replace the text values with the cell you want referenced:

=IF(AND(A1=12,B10=15,C22=0),Z10, X11)

--
Kevin Backmann


"MikeM" wrote:

I want to return a value from another cell as opposed to a "true" or "false",
is this possible?
MikeM

"Dave Peterson" wrote:

=if(and(a1=5,b1="yes"),"both are true","at least one is not true")


MikeM wrote:

Is there a way to combine the "IF" function and the "AND" function in one
formula?

--

Dave Peterson