| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
NESTED IF STATEMENTS
Having a little problem in an excel class, hoping someone might be
able to help. I'm trying to fill in the discount column on a spreadsheet with the following info. The problem states use a nested form of the IF function to calculate 15% if Amount is greater that $300., 10% if Amount is greater than $100., and 0% if Amount is less than $100. The Amount column is cell D5. Anyone know how to write the formula and explain how to go about it? Any help would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too Many Nested IF Statements! | Excel Worksheet Functions | |||
| Nested If statements | Excel Worksheet Functions | |||
| Nested if statements - is there a better way? | Excel Worksheet Functions | |||
| I want to use more than 7 nested if then statements | Excel Worksheet Functions | |||
| Do I need nested IF statements? | Excel Worksheet Functions | |||
Threaded Mode
