Nested If Functions

[cefpe]

KellyMcg03,
First of all forget the tax calulations, I can take care of that.
Employee's wages are listed in columns. One column is the total of th
first two quarters, the second column lists the third quarter.
If the first two quarter's wages are less than $8500 then part or al
of the third quarter' wages must be used to calculated the base. Fo
instance, quarters 1 & 2 wages for an employee are $4000 and the thir
quarter is $9000 then an additional tax must be paid on the additiona
$4500. (tax was allready paid on the $4000. There also could be a cas
where an employee was paid no $ in the first two quarters and recieve
wages in the third quarter that are taxable,
The other case is if the employee was paid more than $8500 in the firs
two quarters then no tax was due in the third quarter.
Something like below is needed but I have not solved the formula yet.

=IF(A1>8500, IF(A2<8500, etc. two nested IF arguements.

Thanks,
C. Furta

 

[KellyMcG03]

cefpe -

Please forgive me, I am going on vacation next week and I believe m
mind is already there... anyway. I think you are just putting in you
nested functions improperly.

Be sure to put () around any formula/function nested in a function.

Such as (I know this formula isn't what your looking for)

=IF(A1>8500,"",(IF(A2<8500,(formula for taxing),"")

If A1 is greater than 8500, do nothing, if it is then if A2 is les
than 8500, continue with tax formula.

Ugh! I really hope this helps! :rolleyes