Forum Discussion

Raiden74's avatar
Raiden74
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?  ...
excel
Formulas and Functions
  • Raiden74's avatar
    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 ( ; )...

bhushan_z's avatar
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's avatar
    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's avatar
      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 ( ; )...

Resources