Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

enter image description here

share|improve this question
    
The statement is correct. I tried it and works for me. Are you sure you use it correctly?? –  Illyes Istvan Nov 23 '12 at 18:52
    
Are you currently focused on the cell with the formula in it? When you press Enter, does the formula evaluate? –  dangowans Nov 23 '12 at 18:55
    
The screenshot looks like it has semi colons between the arguments instead of commas. Try semi colons. –  dangowans Nov 23 '12 at 18:58

1 Answer 1

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.

=IF(D7=D6;1;0)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.