Payroll: Withholding tax formula for excel?

is there a formula/function in excel that lets me

Example:
Earnings
Carl, ME 5600
Andy, Z 2700


41.67 208.33 708.33
10% 15% 20%
over over over

Z 833 2500 5833
S/ME 5000 6667 10000
ME1/S1 7083 8750 12083


Basically what i want to do is:

Carl's an ME so his computations are then based on the S/ME row. He’s earned 5600 and since 5000<5600<6667, his computations are now based on the 1st column.
The computations go like this:
5600 – 5000 = 600 X 10% = 60 + 41.67 = 101.67

Andy’s:
2700 – 2500 = 200 X 15% = 30 + 208.33 = 238.33

Can all of this be done with just a single formula??
Thanks in advance for the replies