You've entered too many arguments for this function

  • Thread starter Thread starter aaron.clanton
  • Start date Start date
A

aaron.clanton

I need help guys....i used this formula

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)))

And got this error

You've entered too many arguments for this function

any suggestions?
 
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))))
 
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?



I corrected the syntax so that it was a valid formula. What did you want?

Hmmm...
no error but i get a the word false in the text box. What did you do?
 
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?

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?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top