Excel formulas

  • Thread starter Thread starter rjaworsky
  • Start date Start date
R

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
 
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.
Click to expand...
...

=MIN(3000,X99)*25%+MAX(0,X99-3000)*20%
 
=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)
 
Back
Top