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