Forum Discussion

Copper Contributor

May 27, 2020

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?

Thank you.

excel

Formulas and Functions

Raiden74
May 27, 2020
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 ( ; )...

4 Replies

SergeiBaklan
Diamond Contributor
May 27, 2020
Raiden74

By the way, is that Excel Online?
bhushan_z
Iron Contributor
May 27, 2020
Raiden74 I assume 2 things here. Try below 2 for the fix.

1) Make sure you have not ( ' ) this symbol before ( = ) equal to sign
or
2) On the top panel, go to FORMULAS and click on SHOW FORMULAS
- Raiden74
  Copper Contributor
  May 27, 2020
  bhushan_z
  
  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.
  - Raiden74
    Copper Contributor
    May 27, 2020
    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 ( ; )...