| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Several Table, need the total discount
I have several tables RED, BLUE, YELLOW and TOTAL DISCOUNT
I need to calculate the greatest amount of the three and give a total discount. EX. 2ND DAY=$5, 3RD DAY=$7, TODAY'S PRICE=$8 TOTAL DISCOUNT WOULD EQUAL 2ND DAY (SINCE ITS THE LOWEST) TO TODAY'S PRICE = $5-$8=TOTAL DISCOUNT=$3 and in the same respect, I need to show that if TODAY'S PRICE is the lowest to equal TOTAL DISCOUNT=ZERO |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract a discount from total price? | Excel Discussion (Misc queries) | |||
| How do I Minus 10% discount On my Excel Invoices On the Sub Total | Excel Worksheet Functions | |||
| Percentage Discount Total | Excel Discussion (Misc queries) | |||
| Percentage Discount Total | Excel Discussion (Misc queries) | |||
| create a function for Discount if qty > 50 then take 5% off total | Excel Worksheet Functions | |||
Threaded Mode
