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? 
  • Riny_van_Eekelen's avatar
    Jan 15, 2022

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

     

    Note the double quotation marks rather than apostrophes.

     

Resources