Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If Then statement
Is it possible to have an "AND" condition in an "If Then" statement?
For example, how would you write "if cell A1 and C1 and E1 all equal "x", then return "yes". If not, return "no". |
#2
|
|||
|
|||
=IF(AND(A1="x",C1="x",E1="x"),"yes","no")
-- Regards, Peo Sjoblom "alm09" wrote in message ... Is it possible to have an "AND" condition in an "If Then" statement? For example, how would you write "if cell A1 and C1 and E1 all equal "x", then return "yes". If not, return "no". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |