Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incremental increase in a formula
Hi all,
I am wanting to multiply an order by a fixed cost (0.055c) up to an order quantity of 13,000. Thereafter, for every FULL 500 units over the 13,000 the cost will increase by 0.001c. Examples: 1. Order = 13,000 - Cost = 715 2. Order = 14,000 - Cost = 798 (0.001*2 + 0.055 * 14,000) 3. Order = 14,400 - Cost = 798 How can I put this into a single formula? Thanks in advance. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell incremental increase | Excel Worksheet Functions | |||
Incremental formula problem | Excel Worksheet Functions | |||
Formula for incremental increase | Excel Worksheet Functions | |||
Formula for incremental increase | Excel Worksheet Functions | |||
Formula for incremental increase | Excel Worksheet Functions |