Combining Functions

  • Thread starter Thread starter MikeM
  • Start date Start date
M

MikeM

Is there a way to combine the "IF" function and the "AND" function in one
formula?
 
=if(and(a1=5,b1="yes"),"both are true","at least one is not true")
 
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")
 
I want to return a value from another cell as opposed to a "true" or "false",
is this possible?
MikeM
 
Just replace the text values with the cell you want referenced:

=IF(AND(A1=12,B10=15,C22=0),Z10, X11)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Functions 3
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
Indirect & addree combination 2
Combine Formulas 1
How can I combine cell contents? 1
Roundup Function 5
Concatenate 1
How to use Sumifs with vertically and horizontally criterias 1

Back
Top