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

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

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