| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Statement with ANDs
Hi. I'm trying to do the following:
Create a conditional statement where if a group of ideas are true, it will produce the result. Meaning, if a6a5 and a5a4 and a4a3 then a6/a3, if a5a4 and a4a3, then a5/a3, etc. How can I do this?? Thanks! -- Thanks! Stephen |
|
#2
|
|||
|
|||
|
=IF(AND(A6A5,A5A4),A6/A3,otherwise)
"Stephen" wrote: Hi. I'm trying to do the following: Create a conditional statement where if a group of ideas are true, it will produce the result. Meaning, if a6a5 and a5a4 and a4a3 then a6/a3, if a5a4 and a4a3, then a5/a3, etc. How can I do this?? Thanks! -- Thanks! Stephen |
|
#3
|
|||
|
|||
|
Try something like this:
=IF(AND(A6<A5,A5<A4,A4<A3),A6/A$3,) After the comma at the end is what you want to return if the equation is false. HTH, Paul "Stephen" wrote in message ... Hi. I'm trying to do the following: Create a conditional statement where if a group of ideas are true, it will produce the result. Meaning, if a6a5 and a5a4 and a4a3 then a6/a3, if a5a4 and a4a3, then a5/a3, etc. How can I do this?? Thanks! -- Thanks! Stephen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble with a conditional statement | New Users to Excel | |||
| IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
| How do I write a conditional statement in Excel to count if two c. | Excel Worksheet Functions | |||
| Conditional if statement | Excel Worksheet Functions | |||
Linear Mode
