Here's two ways:

=MIN(A1,41100)*0.045+MAX(0,A1-41100)*0.06

=A1*0.045+MAX(0,A1-41100)*0.015


--
Jim
"pgruening" wrote
in message ...
|
| 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=478763
|