Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Statement question
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
You aren't nesting the IF statements properly. The right parenthesis after the
19.04 doesn't belong there, but rather at the end of the formula, 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)))) BUT you don't need any SUM functions. You use SUM when you want to add several numbers. You aren't doing that. This should be written as =IF(C3<112,0,IF(C3<298,C3*0.17-19.04,IF(C3<322,C3*0.37-78.7669))) On Mon, 04 Apr 2005 03:15:35 GMT, "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 |
#5
|
|||
|
|||
=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 |
#6
|
|||
|
|||
Thanks, Works like a charm.
"Biff" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statement Question | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |