| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add 5 to amounts <25, 10 to amounts 25<100, etc?
I would like a formula that will add preset amounts to another amount.
If my cost for an item is <$25 I would like to mark it up by $5, if it is $25 but <$100 I would like to mark it up by $10, if it's 100 but <250 I would like to mark it up by $15, etc. Is there a formula that will do this for me? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL | Excel Worksheet Functions | |||
| Linking total amounts | Excel Worksheet Functions | |||
| How can I sum amounts formated as B O L D only? | Excel Discussion (Misc queries) | |||
| How can I sum only amounts that are in BOLD format within a column | New Users to Excel | |||
| sumproduct to add total amounts for the month | Excel Worksheet Functions | |||
Threaded Mode
