Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
pgruening
 
Posts: n/a
Default calculating different percentages depending on amount


I'd appreciate help with a formula

I need a formula to calculate the following

4.5% of any amount up to and equal to $41,100.00 PLUS 6.00% on any
amount above $41,100.

ie $20,000 would be (20,000 x .045) $900.00

ie $50,000 would be [(41,100 x .05) + (8,900 x .060)] $2,383.50

Thanks Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=478783

  #2   Report Post  
goober
 
Posts: n/a
Default calculating different percentages depending on amount


Here's one which may work. Just substitute A1 with the cell your
information is in.

=IF(A1<=41100,A1*.045,(A1*.05)+((A1-41100)*.06))


I'd appreciate help with a formula

I need a formula to calculate the following

4.5% of any amount up to and equal to $41,100.00 PLUS 6.00% on any
amount above $41,100.

ie $20,000 would be (20,000 x .045) $900.00

ie $50,000 would be [(41,100 x .05) + (8,900 x .060)] $2,383.50

Thanks Peter


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=478783

  #3   Report Post  
pgruening
 
Posts: n/a
Default calculating different percentages depending on amount


THe formula worked for amount $41,100 or less but didn't for amounts
above.

At first I thought it was because of a wrong percentage in the second
half of the formula but that wasn't it.

Any suggestions would be appreciated

Thanks Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=478783

  #4   Report Post  
FxM
 
Posts: n/a
Default calculating different percentages depending on amount

pgruening wrote:
I'd appreciate help with a formula

I need a formula to calculate the following

4.5% of any amount up to and equal to $41,100.00 PLUS 6.00% on any
amount above $41,100.

ie $20,000 would be (20,000 x .045) $900.00

ie $50,000 would be [(41,100 x .05) + (8,900 x .060)] $2,383.50

Thanks Peter




Hi Peter,

Looks like
=min(amount,41100)*0.045 + (max(amount-41100,0))*0.060

@+
FxM
  #5   Report Post  
pgruening
 
Posts: n/a
Default calculating different percentages depending on amount


Thanks figured it out


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=478783



  #6   Report Post  
Gary''s Student
 
Posts: n/a
Default calculating different percentages depending on amount

If A1 contains the amount then
enter: =IF(A141100,1849.5+(A1-41100)*0.06,0.045*A1)
--
Gary''s Student


"pgruening" wrote:


I'd appreciate help with a formula

I need a formula to calculate the following

4.5% of any amount up to and equal to $41,100.00 PLUS 6.00% on any
amount above $41,100.

ie $20,000 would be (20,000 x .045) $900.00

ie $50,000 would be [(41,100 x .05) + (8,900 x .060)] $2,383.50

Thanks Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=478783


  #7   Report Post  
David Biddulph
 
Posts: n/a
Default calculating different percentages depending on amount

"goober" wrote in
message ...

Here's one which may work. Just substitute A1 with the cell your
information is in.

=IF(A1<=41100,A1*.045,(A1*.05)+((A1-41100)*.06))


Or did you mean:
=IF(A1<=41100,A1*.045,(A1*.045)+((A1-41100)*.06)) ?
--
David Biddulph



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating percentages in pivot tables on subtotals David Ruderman - Chapman University Excel Worksheet Functions 1 November 24th 05 05:54 PM
Calculating number of periods when payment amount changes Dan Patrick Excel Worksheet Functions 1 August 2nd 05 05:57 PM
calculating percentages msdobe Excel Discussion (Misc queries) 6 July 29th 05 04:46 PM
Calculating total amount of sales for each salesman Exedate Excel Worksheet Functions 4 May 27th 05 09:53 PM
Calculating Percentages with Variables tssjhs Excel Worksheet Functions 1 January 28th 05 02:27 AM


All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"