| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct Formula
What is the formula for below equation?
Qty Order=2 Unit Price=USD 100 Discount=5% (less) Freight Chrgs=2% (add) Net Amount=? In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) Can you simplify this formula? Thanks. Rechie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Direct to sheet | Excel Discussion (Misc queries) | |||
| Can you direct me. | Excel Discussion (Misc queries) | |||
| MS Query Direct Invoking? | Excel Discussion (Misc queries) | |||
| Direct reference | Excel Worksheet Functions | |||
| Emailing XML direct from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
