TRUE OR FALSE ?

Question

I am trying to do what I believe should be very simple, but I cannot find the answer.  I am in Excel 2007, with three columns of data.  Column A is questions.   Column B is either a "T" or an "F" for true or false.  In Column C, I am trying to build a formula that will take each T and convert it to a "1", each F and convert it to a "0".  Can't figure it out.  Thanks for your help.

Answer 1

... Column B is either a "T" or an "F" for true or false.  In Column C, I am trying to build a formula that will take each T and convert it to a "1", each F and convert it to a "0" ...

There is an inherent flaw in your logic and depending on what you plan to do with the 1'a and 0's it could have detrimental effects.

The problem as I see it will be totaling the 1'a and 0's since you haven't provided for the eventuality of a blank cell which will likely read a 0 . In any event, here are a couple of possibilities,

=IF(B1="T", 1, IF(B1="F", 0, ""))

  ... or,

=IF(B1="T",TRUE, IF(B1="F",FALSE, ""))

  ... or,

=B1="T"

Remember that a boolean value of TRUE evaluates to a 1 and a FALSE evaluates to a 0.

Answer 2

Rick - I have printed out your solutions in case my first solution runs short for whatever unanticipatable reason.  Is that a word - I guess so - I said it.  ;-D

Seriously appreciate you taking out your time to try and help me.  THANK YOU.

V/R//

Answer 3

Jeeped - THANK YOU for your help.  I figured, like most other things in life, this wasn't going to be a hard one for someone who knew better than me what to do - - simple fact is, I couldn't do it.  I appreciate your help.  

The first solution worked.  And I will be "leary" about the zero.  If it becomes an issue, I will shift the "1" and "0" to "2" and "1".

V/R//

Answer 4

=B1="T"

For this one, you probably would want this...

=1*(B1="T")

in order to get 1 or 0 as the displayed result. A more off-the-wall method for the above might be this...

=CHOOSE(1+(A14="T"),0,1)

or even this...

=1*MID("01",1+(A14="T"),1)