Multiple if formula syntax...not nested, just sequential

Your if statement has 4 criteria

=IF(A6=$W$2,C6+$X$2,IF(A6=$W$3,C6+$X$3),IF(A6=$W$4,C6+$X$4))

Criteria 1: A6=$W$2
Criteria 2: C6+$X$2
Criteria 3: IF(A6=$W$3,C6+$X$3)
Criteria 4: IF(A6=$W$4,C6+$X$4)

You can of course only have 3
I have a feeling you made a simple error, so let me know if you need more help

clay

You have

=IF(A6=$W$2,C6+$X$2,IF(A6=$W$3,C6+$X$3),IF(A6=$W$4,C6+$X$4))

Should be

=IF(A6=$W$2,C6+$X$2,IF(A6=$W$3,C6+$X$3,IF(A6=$W$4,C6+$X$4,???)))

??? is a possible condition you should consider (not = to $W$2,3,or 4)

Move that first closed parenthesis to the end:

=IF(A6=$W$2,C6+$X$2,IF(A6=$W$3,C6+$X$3,IF(A6=$W$4,C6+$X$4)))

But your subject implies you don't want to nest these statements. If A6 must be equal to either W2, W3, or W4, you can forego the last IF statment. Otherwise, you should put in a result at the end of your final IF statement in case A6 is not equal to any of W2, W3, or W4.

Thanks so much!