Hi!
Well, for starters, you don't need any of the SUM
functions in either formula. They're basically doing
nothing. They're just summing a single number returned by
a particular IF function.
You can write those formulas as:
=IF(C3<112,0,IF(C3<298,C3*0.17-19.04))
=IF(C3<112,0,IF(C3<298,C3*0.17-19.04,IF(C3<322,C3*0.37-
78.7669)))
In both cases however, if C3 = 298 and 322 in each
respective formula, You'll get a return of FALSE since you
haven't defined that variable at the end of either formula.
Biff
-----Original Message-----
I can this statement to work
=SUM(IF(C3<112,(0),IF(C3<298,SUM(C3*0.17)-19.04)))
but when I add to it like this
=SUM(IF(C3<112,(0),IF(C3<298,SUM(C3*0.17)-19.04),IF
(C3<322,SUM(C3*0.37)-78.7669))
I get error message "Too many arguements for this
function"
Can someone tell me where I'm going wrong
TIA
.
|