If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formulas
I need to create a formula that figures the amount in a cell at different rates
There is a base charge for a certain amount in the cell (2000), after the base is reached the amount will change it will be so much for each 1000. I know only the basic function but don't know how to write a formula for that. -- Needing help |
#2
|
|||
|
|||
formulas
Hi Denice,
is this for a commission-type payment scheme, where the first 2000 of sales would be at a certain percentage, then the next 1000 would be at a different percentage and so on? If so, how many different rates do you have (and what are they), and what is the largest "amount" likely to be encountered? Pete denice wrote: I need to create a formula that figures the amount in a cell at different rates There is a base charge for a certain amount in the cell (2000), after the base is reached the amount will change it will be so much for each 1000. I know only the basic function but don't know how to write a formula for that. -- Needing help |
#3
|
|||
|
|||
formulas
try something like
=(base cost)+(incremental cost)*roundup(max(0,nu/1000-2),0) assuming the base cost will be there for any number, and the incremental cost will be there for any part of a thousand. "denice" wrote: I need to create a formula that figures the amount in a cell at different rates There is a base charge for a certain amount in the cell (2000), after the base is reached the amount will change it will be so much for each 1000. I know only the basic function but don't know how to write a formula for that. -- Needing help |
Thread Tools | |
Display Modes | |
|
|