Thread: Dummy Variables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rz-illini85 rz-illini85 is offline
external usenet poster
 
Posts: 1
Default Dummy Variables

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