Dummy Variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Of course it would, I kep making that error <g>

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top