Forum Discussion
Tariro
Oct 13, 2021Copper Contributor
Excel If Statement no working
Hi all. I have this IF statement in the formula bar =IF(E2="male","1","0"). but when I press enter I get the "There's a problem with this formula" error. I want to use the IF statement to return ...
Riny_van_Eekelen
Oct 13, 2021Platinum Contributor
Tariro Have look at the attached file and see which formula you want to use.
- TariroOct 13, 2021Copper Contributor
Riny_van_Eekelen , this is what I`m getting when I open the file - I can't see the formula?
- Riny_van_EekelenOct 13, 2021Platinum Contributor
Tariro Don't you see the formulae in column M? The results are in your screen shot.