More than 2 options for 'IF' statement

[brncfan7]

I have a dropdown list consisting of three options: "YES, VARIATION, NO"

I want to display data in the next cell based on the following,

If "yes" is selected, data from cell t2 is displayed
If "no" is selected, data is zero
If "variation" is selected, data from cell w2 is displayed

How can I do this? To my knowledge the =IF() function of a cell can only have two inputs.

[nofzinger]

=IF(A1="yes",t2,IF(A1="no",0,IF(A1="variation",w2,"Not One of the Three")))

That should work. You need to "nest" the formulas. You can nest a lot more (up to 7 or 10 maybe).

[brncfan7]

Thanks for the reply, but I'm getting an error with that formula you provided of #NAME

Here is my formula: =IF(W2=”YES”,L2,IF(W2=”NO”,0,IF(W2=”VARIATION”,V2)))

For reference:

The cell with the dropdown list is W2

The cell for "YES" values is L2

The cell for "VARIATION" values is V2

And like I posted, I want the formula to return 0 if "NO" is selected.

Any idea what I'm doing wrong?

[nofzinger]

You're last "if" statement needs a third component. That's why I put the "Not one of the three", because you need that additional piece. It's just what you want to show if none of the three are present.

[brncfan7]

I added that in but I'm still getting the same error message

[nofzinger]

Can you attach your file so that I can look at it?

[NBVC]

The quote marks are wrong: try:

=IF(W2="YES",L2,IF(W2="NO",0,IF(W2="VARIATION",V2,"Not One of the Three")))

[brncfan7]

Here's the file

[nofzinger]

Try this....

[NBVC]

As I mentioned you have wrong quotes around the strings.. and your last string has no quotes at all... see my formula above.