I'd appreciate help on a formula to calculate pension contributions
based on annual salary where contributions are based on 4.5% of the
first $41,100 of salary PLUS 6% on the balance of the salary. For
example annual salary $50,000 (I wish!!!) Contributions of $1,849.50
(4.5% of $41,100) PLUS $534.00 (6% of $8,900) equal $2,383.50 NOTE
While this is example is for a salary $41,100 the formula who also
need to calculate for salaries below $41,100.

Thanks for any help Peter


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