Need a formula that can calculate employers cost on employees payroll with the following.

[Jmatt856]

Employee wages = x

Social security tax rate = 6.2%
Social security limit = $128,700(no tax payed after)

FUTA tax rate = .6%
FUTA limit = $7,000

Medicare tax rate = 1.45%
No limit

 

[Eric W]

Try:

=MIN(A1,128700)*6.2%+MIN(7000,A1)*0.6%+A1*1.45%