Thread: You've entered too many arguments for this function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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 With QuoteReply With Quote