Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |