Dummy Variables

[rz-illini85]

I have a column of 4 different Letters(H,B,A,S) and i want to create three
different dummy columns of 1's and 0's to do a regression. How do i create
an if statement to say if column A is H then 1 if not then 0? I've tried:
=if(A2=H,1,0) and it said there was Name error

Help Please

 

[Teethless mama]

=IF(A2="H",1,0)

 

[Bob Phillips]

=--A2="H"

etc.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[RichardSchollar]

Bob

Wouldn't that need to be:

=--(A2="H")

Richard

 

[Bob Phillips]

Of course it would, I kep making that error <g>

Bob

(change the xxxx to gmail if mailing direct)