One more thing....
If you want to copy the formula down through rows
where Col_F may have no values,

use this variation:
H6: =IF(F60,MIN(MAX(27600-(G6-F6),0),F6)*0.026,0)

or this:
H6: =(F60)*MIN(MAX(27600-(G6-F6),0),F6)*0.026

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Ron Coderre" wrote in message
...
Try this:
H6: =MIN(MAX(27600-(G6-F6),0),F6)*0.026

Copy that formula down as far as you need

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Tia" wrote in message
...
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!!