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

3 Replies

  • 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