| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using multiple IF conditions
I am having a difficult time with an IF statement.
I have a value in cell A1 that triggers a response in cell A5. If cell A1 = 0, Cell A5 should =0 If cell A1 is 0and<=300,Cell A5 should =495 If cell A1 is 300, Cell A5 should =795. The PROBLEM here is that I can't seem to use "and" conditions within an If statement. I've tried "between" and "And" and that doesn't work either. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
| How do I add multiple values that match multiple conditions? | Excel Discussion (Misc queries) | |||
| Multiple conditions and multiple return values | Excel Worksheet Functions | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Threaded Mode
