IF(SUM(B9:K9)8000,0,((SUM(B9:K9)-8000)*-$B$72))
i think your problem is this....
you have already tested for < 8000(what happens if = 8000),so
IF(SUM(B9:K9)8000 is false ,it will evaluate ,((SUM(B9:K9)-8000)*-$B$72))
and stop.Your if statements need to be logical and keep going forward like
the first two ifs...
--
paul
remove nospam for email addy!



"questionsforms" wrote:

I'm trying to create an IF function to calculate some payroll taxes. Here's
the formula that I came up with
=IF(AND(L9<8000,SUM(B9:L9)<8000),L9*$B$72,IF(SUM(B 9:K9)8000,0,((SUM(B9:K9)-8000)*-$B$72))+IF(AND(L18<8000,SUM(B18:L18)<8000),L18*$B$ 72,IF(SUM(B18:K18)8000,0,((SUM(B18:K18))-8000)*-$B$72 ETC. it's long formula

It works properly until one of the if statements in a section (
IF(SUM(B9:K9)8000,0,((SUM(B9:K9)-8000)*-$B$72)) ) come up with the answer 0
then the formula stops and doesn't continue to the next section. What am I
doing wrong?
Thanks!
Terri