Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array function with more than 29 arguments [email protected] Excel Discussion (Misc queries) 3 April 15th 07 03:40 PM
If Function with 3 arguments CIW Excel Worksheet Functions 5 December 5th 06 10:34 AM
Function Arguments Jessica Excel Worksheet Functions 4 September 18th 06 03:05 AM
Is it possible to use more than 8 arguments in a function? Breesmom Excel Discussion (Misc queries) 1 December 21st 05 03:04 AM
Match Function arguments Stan Altshuller Excel Worksheet Functions 3 March 11th 05 08:48 PM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"