Combining Functions
 

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

Combining Functions
 

=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

Combining Functions
 

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")
--
Kevin Backmann


"MikeM" wrote:

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

Combining Functions
 

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

Combining Functions
 

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

Combining Functions
 

Thanks for your help!

"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