What am I doing wrong here, using the =IF in excel? I type =IF(D7=D6,1,0)
see

This is likely due to your region settings. This forum post mentions a similar problem. If the comma is used when separating the whole and fractional parts of a number, it cannot be used to separate arguments in a formula. To review how your computer interprets numbers, you can look at the "Regional and Language Options" in the Control Panel. Look at the "Number" sample. I'm using "English (United States)", so my number is "123,456,789.00". (Note the decimal point separating the whole and fractional parts of the number.) Looking at your screenshot, it looks like there are semicolons between the formula arguments in the tooltip, not commas. Try using semicolons rather than commas to separate the arguments.



While dangowans' answer is a good workaround, it doesn't solve the problem for longtime users of Excel who are fluent in typing formulas using commas. Switching to using a semicolon after using Excel for over 20 years is not an option for me. So here is how to "fix" what Microsoft has broken:
Excel will now accept formulas in the old way, and you will be able to use it like you always have. References: 

