If cell = "text" then x=1, if not x=2

[emilycurious]

Okay, apologies from the start, this is probably the most basic newbie question but I cannot get this to work after trawling Excel help and many web pages.

I have a cell that has a text result of Yes or No, and depending on that answer I need x (or the cell result) to be 1 (yes) or 2 (no)

Tried these, can't get them to work:
If(C1 = yes, x=1, x=2)
If(C1 = "yes", x=1, x=2)

Excel:mac 2011 14.4.3 (140616)

Thanx
x
Emily

[TheCman81]

=IF(C1="Yes",1,2)

[ARGK]

Hi Emily
No question or query is classed as "basic". We only know what we know at the end of the day. This is why these forums exist so that we can help and support each other .
If I underestadn you correctly then try this formula:
=IF(C1="Yes",1,2)
This would place a "1" in the cell if C1 was equal to "Yes", if not it will place a "2" in the cell.
Hope this helps.
Tony

[Tony Valko]

The very robust version of the formula would be:

=IF(C1="Yes",1,IF(C1="No",2,""))

If the only possible cell entries will be either Yes or No (and nothing else, not even a blank cell):

=1+(C1="No")

[emilycurious]

Awesome, you guys are QUICK!
Thanx again!
x
Em

[Tony Valko]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.