| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to: Multiple "if" statements?
NEWBIE ALERT*:
OK, please bare with me. What is the method for combining multiple if statements in one cell's formula? In English, the formula would be something like: "If cell B3 is less than 1000 then display the price that is in cell F2, if cell B3 is more than 1000 but less than 2000 then display the price that is in cell F3..etc, etc..." Besides HOW to write that formula, I have a question: How many conditions can be combined in one formula? I have about 20 different "less than or greater than" items. Is this the best way to accomplish this? (I suspect NOT) Thanks for reading! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF statements | Excel Worksheet Functions | |||
| How do I set up multiple if statements in Excel? | Excel Worksheet Functions | |||
| Logical Function - Multiple IF statements | Excel Worksheet Functions | |||
| Combining IF and multiple SUMIF statements, if A>0 & B is between | Excel Worksheet Functions | |||
| multiple IF statements | Excel Worksheet Functions | |||
Threaded Mode
