Forum Discussion
Solved
If formula error
I'm trying to use the IF formula to display a different name, depending if a cell number is greater than another, but it just turns the cell borders dotted red. Any ideias what the problem is? ...
Ah, I tried with ( ; ) instead of ( , ) and it worked.
But it's weird, because in https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2, it has ( , ) and not ( ; )...
No, there isn't a ( ' ) before the ( = ).
Here is a screenshot of the Show Formulas and I was using excel online, I switched to the desktop app and now I'm getting this error.
Ah, I tried with ( ; ) instead of ( , ) and it worked.
But it's weird, because in https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2, it has ( , ) and not ( ; )...