This should work for you:

=IF(A141100,(41100*0.045)+((A1-41100)*0.06),A1*0.045) where A1 holds
the salary to calculate.

Values less than or = to $41,100 will calculate at 4.5%

HTH


--
swatsp0p


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