Excel formulas

[rjaworsky]

If I have a dollar amount in a cell how do I create a
formula in another cell that takes that adds 25% to the
1st $3,000's of that amount and then adds 20% to the
remaining balance and then adds those two sums together.

Example: I have the amount of $5000 in cell A1. If I take
25% of the 1st 3,000 of $5000 I get $750. I then need to
take 20% of the remaining balance ($2,000) which gives me
an amount of $400. Then I need to add $750 plus $400 and
put that amount of $1150 in cell B1.

What is my formula for cell B1?

Thanks

 

[Ken Wright]

=MIN(A1,3000)*0.25+MAX(0,A1-3000)*0.2

 

[Harlan Grove]

If I have a dollar amount in a cell how do I create a
formula in another cell that takes that adds 25% to the
1st $3,000's of that amount and then adds 20% to the
remaining balance and then adds those two sums together.

...

=MIN(3000,X99)*25%+MAX(0,X99-3000)*20%

 

[Bob Phillips]

=MIN(A1,3000)*0.25+MAX(0,A1-3000)*0.2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

I've got to ask, why X99?

Bob

...
..

=MIN(3000,X99)*25%+MAX(0,X99-3000)*20%

 

[Harlan Grove]

I've got to ask, why X99?

...

My favorite 'for example' cell, though I suppose column EG would make more
sense.

 

[Bob Phillips]

...
..

My favorite 'for example' cell, though I suppose column EG would make more
sense.

Made me smile.