This part "However, if YTD payroll is more than 7000, then it should only
multiply the difference from the last payroll to 7000,
then multiply by 0.008. " is unclear.
Also why did you mention E4 - it is not used in formula

Try this =IF(G4<7000,F4,(F4-7000))*0.008 and tell me what is wrong
Note I put the 0.008 outside the IF since it is common to both parts

Maybe two or thee example values and results would help us.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Tia" wrote in message
...
I'm putting together a worksheet for payroll purposes. I need a formula
that calculates FUTA based on the following. Cap out at $7000. I thought
I
had a formula that worked right, but now that it has to refer to YTD
payroll
it isn't working properly.

G4 is the YTD Payroll Total
F4 is the payroll before tax free deductions
E4 is the payroll after tax free deductions

=IF(G4<7000,F4,IF(G4-F47000,0,(F4(F4-7000))))*0.008

The formula should look at YTD Payroll amount if less than 7000, multiply
F4
by 0.008, which it appears to do. However, if YTD payroll is more than
7000,
then it should only multiply the difference from the last payroll to 7000,
then multiply by 0.008. I'm obviously missing some important part of this
formula but after walking through it many times, I'm still not seeing
it....

Thanks for any and all help!