| 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
|
|||
|
|||
|
Try this:
=IF(AND(A1=10,A2=10,A3=10),"Yes","No") On Tue, 22 Feb 2005 08:41:03 -0800, "alm09" wrote: 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 with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
Linear Mode
