Forum Discussion

Ekow1's avatar
Ekow1
Copper Contributor
Jan 15, 2022
Solved

Formula not working

I have tried the =IF(logical_test, value if true, value if false) formula but Excel does not seem to be recognizing it. Could someone please help? 
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jan 15, 2022

    Ekow1 Use =IF(BE2="Britain",1,0) 

     

    Note the double quotation marks rather than apostrophes.

     

Ekow1's avatar
Ekow1
Copper Contributor
Jan 15, 2022
This is the formula I put in: =IF(BE2='Britain',1,0) I am trying to create a dummy variable coding Britain as 1 and France as 0
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 15, 2022

Ekow1 Use =IF(BE2="Britain",1,0) 

 

Note the double quotation marks rather than apostrophes.

 

  • Ekow1's avatar
    Ekow1
    Copper Contributor
    Jan 15, 2022
    Thank you very much! It's working now

Resources