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 -