View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Couple of things:

1) You don't need the SUM()s

2) Try

=IF(C3<112,0,IF(C3<298,C3*0.17-19.04,IF(C3<322,C3*0.37-78.7889,"Greater
than or equal to 322")))



In article ,
"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.766
9))
I get error message "Too many arguements for this function"

Can someone tell me where I'm going wrong
TIA