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