=IF(C3<112,0,IF(C3<298,(C3*0.17)-19.04,IF(C3<322,(C3*0.37)-78.7669,"Not
Defined")))
When C3 = 322, you'll get "Not Defined".
gryfon wrote:
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
|