I have a payroll spreadsheet that has the following formula to calculate
SUTA. It worked great until an employee capped out on the amount taxed for
SUTa then I get a REF! error in the cell. The following is located in column
H.
=IF(G7<26700, F7,IF(G7-F7262700,0,(F7(F7-26700))))*0.026

G7=YTD Payroll
F7=Payroll w/0 deductions
H7=SUTA Calculation

The employee had the following information
G6=25200.00
F6=6000.00
H6=156.00

G7=31800.00
F7=6600.00
H7=REF!!