I apologize for not being more clear. Suta is calculated on income up to
$26700. So when a income is below that the formula worked fine. Once the
employees income surpasses it, than it needs to still calculate SUTA on the
amount up to 26700. So for example on the 1st payroll, an employee made
$21000, it's just that amount times by the 0.026(SUTA). The second payroll
the employee made $3100. The formula would need to pay the 0.026 on the
amount from $21000 to $26700. Then on the third payroll, the SUTA would
calculate to 0.

So in the portion of the formula that isn't working, it is suppose to have
evaluated the difference of the amount already paid on up to the $26700.
Hopefully, that helps.

Thanks for your help.


"Mike H" wrote:

I meant

F7(F7-26700)

"Mike H" wrote:

Hi,

I can't answer your question fully because I have no idea what capped out
for SUTA means but is clear is from the data you have given that all
expressions evaluate as False so your formula is evaluating the expression

F7(F7-2600)

Which is giving the REF error. What would you like it to do?

Mike

"Tia" wrote:

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!!