| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to add different vaules based on qauntity, is this possible?
Here is a brief overview of what I'm trying to do. I need to find a grand a
sum, but here is the thing. There is a discount for the first 5 units, so unit one is 99.99 unit 2 94.99 unit 3 89.99 unit 4 84.99 unit 5 79.99 but then anything 6 or above goes back to 89.99 so for example if I have a total of 9 it would look like this 1. 99.99 2. 94.99 3. 89.99 4. 84.99 5. 79.99 6. 89.99 7. 89.99 8. 89.99 9. 89.99 For a total of 809.91 I just dont how to put this into a formula format. Any help would be greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and add vaules | Excel Worksheet Functions | |||
| Sum first five vaules of changing range | Excel Discussion (Misc queries) | |||
| If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules | Excel Worksheet Functions | |||
| Truning 0 vaules red | Excel Worksheet Functions | |||
| copy/paste vaules, not formulas | New Users to Excel | |||
Threaded Mode
