| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
You've entered too many arguments for this function
I need help guys....i used this formula
IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application manager",SUMPRODUCT(E$9:H$9,E13:H13))) And got this error You've entered too many arguments for this function any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
You've entered too many arguments for this function
Try:
=IF(C13="developer", SUMPRODUCT(E$10:H$10, E13:H13), IF(C13="business analyst", SUMPRODUCT(E$9:H$9, E13:H13), IF(C13="application manager", SUMPRODUCT(E$9:H$9, E13:H13)))) In article .com, wrote: I need help guys....i used this formula IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application manager",SUMPRODUCT(E$9:H$9,E13:H13))) And got this error You've entered too many arguments for this function any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
You've entered too many arguments for this function
Hmmm...
no error but i get a the word false in the text box. What did you do? On Aug 14, 4:03 pm, JE McGimpsey wrote: Try: =IF(C13="developer", SUMPRODUCT(E$10:H$10, E13:H13), IF(C13="business analyst", SUMPRODUCT(E$9:H$9, E13:H13), IF(C13="application manager", SUMPRODUCT(E$9:H$9, E13:H13)))) In article .com, wrote: I need help guys....i used this formula IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application manager",SUMPRODUCT(E$9:H$9,E13:H13))) And got this error You've entered too many arguments for this function any suggestions?- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
You've entered too many arguments for this function
I corrected the syntax so that it was a valid formula. What did you want?
In article .com, wrote: Hmmm... no error but i get a the word false in the text box. What did you do? On Aug 14, 4:03 pm, JE McGimpsey wrote: Try: =IF(C13="developer", SUMPRODUCT(E$10:H$10, E13:H13), IF(C13="business analyst", SUMPRODUCT(E$9:H$9, E13:H13), IF(C13="application manager", SUMPRODUCT(E$9:H$9, E13:H13)))) In article .com, wrote: I need help guys....i used this formula IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application manager",SUMPRODUCT(E$9:H$9,E13:H13))) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
You've entered too many arguments for this function
um ok what i need it a if statement that gives me 3 alternatives.
This formula i made is only giving me two values and then false. Am i using the wrong formula? On Aug 14, 4:29 pm, JE McGimpsey wrote: I corrected the syntax so that it was a valid formula. What did you want? In article .com, wrote: Hmmm... no error but i get a the word false in the text box. What did you do? On Aug 14, 4:03 pm, JE McGimpsey wrote: Try: =IF(C13="developer", SUMPRODUCT(E$10:H$10, E13:H13), IF(C13="business analyst", SUMPRODUCT(E$9:H$9, E13:H13), IF(C13="application manager", SUMPRODUCT(E$9:H$9, E13:H13)))) In article .com, wrote: I need help guys....i used this formula IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application manager",SUMPRODUCT(E$9:H$9,E13:H13)))- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
You've entered too many arguments for this function
It must be saying false because it does not recognise the identity of one of
your inputs. check spelling and for leading or trailing spaces in the one which fails. what do you want it to do when it does not match one of the three options? " wrote: um ok what i need it a if statement that gives me 3 alternatives. This formula i made is only giving me two values and then false. Am i using the wrong formula? On Aug 14, 4:29 pm, JE McGimpsey wrote: I corrected the syntax so that it was a valid formula. What did you want? In article .com, wrote: Hmmm... no error but i get a the word false in the text box. What did you do? On Aug 14, 4:03 pm, JE McGimpsey wrote: Try: =IF(C13="developer", SUMPRODUCT(E$10:H$10, E13:H13), IF(C13="business analyst", SUMPRODUCT(E$9:H$9, E13:H13), IF(C13="application manager", SUMPRODUCT(E$9:H$9, E13:H13)))) In article .com, wrote: I need help guys....i used this formula IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application manager",SUMPRODUCT(E$9:H$9,E13:H13)))- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
You've entered too many arguments for this function
It's hard to say whether you're using the wrong formula when you're
being so general. The formula tests for three different values in C13 ("developer", "business analyst", and "application manager"). If any of these values are found, the corresponding SUMPRODUCT() is calculated. If none are found, then FALSE is returned. Is that the wrong formula? In article .com, wrote: um ok what i need it a if statement that gives me 3 alternatives. This formula i made is only giving me two values and then false. Am i using the wrong formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array function with more than 29 arguments | Excel Discussion (Misc queries) | |||
| If Function with 3 arguments | Excel Worksheet Functions | |||
| Function Arguments | Excel Worksheet Functions | |||
| Is it possible to use more than 8 arguments in a function? | Excel Discussion (Misc queries) | |||
| Match Function arguments | Excel Worksheet Functions | |||
Linear Mode
