IF Target Cell = Yes then 1, if No = 0 how do I set this up

**33CDonnelly** · 03-05-2014, 01:21 PM

I have a spreadsheet with YEs/No in Column A, and I need to output either a 1 or 0 in Column B. I know this is probably and easy solution but I just can't think of it for the life of my. I'm having a brainfart right now

**Pete_UK** · 03-05-2014, 01:25 PM

Put this in B1:

=--(A1="Yes")

then copy down.

Hope this helps.

Pete

**33CDonnelly** · 03-05-2014, 01:26 PM

Currently trying to use a formula similar to =IF(D6=Yes,1,0) but its returning me a name error, Could it be because the cell I'm referencing Is getting it's data for a vlookup function or am I just messing something up?

**33CDonnelly** · 03-05-2014, 01:27 PM

Nevermind that works perfectly! thanks I was missing the " around the Yes lol

**Pete_UK** · 03-05-2014, 01:28 PM

You would need to put quotes around the Yes in that formula:

=IF(D6="Yes",1,0)

That cell reference is a bit different to what you described in Post #1

Hope this helps.

Pete

IF Target Cell = Yes then 1, if No = 0 how do I set this up

LinkBack

Thread Tools

Rate This Thread

Display

IF Target Cell = Yes then 1, if No = 0 how do I set this up

Re: IF Target Cell = Yes then 1, if No = 0 how do I set this up

Re: IF Target Cell = Yes then 1, if No = 0 how do I set this up

Re: IF Target Cell = Yes then 1, if No = 0 how do I set this up

Re: IF Target Cell = Yes then 1, if No = 0 how do I set this up

Thread Information

Users Browsing this Thread

Similar Threads

system time stamp a cell when change in target cell. ( note target cell is formula ref)

[SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?

[SOLVED] Need alternate syntax 'Select Case' on Target.Column and Target.Row at the same time.

Worksheet_CHange (ByVal Target as Range) when target is formula cell

Predicting target values for each month in a year to reach target

Bookmarks

Bookmarks

Posting Permissions