Nested If Functions

[cefpe]

I am having trouble using a nested IF function to determine my UC wage
that I show in the table below.
1st & 2nd quarters 3rd quarter excess
$0 $6600
$6600
$4000 $9900
$4500
$17000 $8000 n
tax due

I would like to write the function as follows:
If the 1st and 2nd quarters are less than $8500 then the UC tax is du
on the excess of first and second quarters up to $8500 (say $4000 wer
the wages in the first two quatrers and $9000 in the third then tax o
$4500 would be due. Finally, if the wages for the first and secon
quarter exceeded $8500 then no tax would be due.

Thanks,
C. Furta

 

[KellyMcG03]

I am trying understand what your needing.

Here is what may work

=IF(A1:B1>=8500,"",(SUM(A1:B1)*7))

A1 = 1ST QTR
B1 = 2ND QTR
7 = TAX PERCENTAGE


If not, please replay and let me know