Hi
Try something likes this assuming figure in a1
=if(a141100,(a1-41100)*.060+41100*.045,a1*.045)
Tina
"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=478763