May 27 2020 07:19 AM
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.
May 27 2020 07:25 AM
@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
May 27 2020 02:27 PM
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.
May 27 2020 02:29 PM - edited May 27 2020 02:30 PM
SolutionAh, I tried with ( ; ) instead of ( , ) and it worked.
But it's weird, because in here, it has ( , ) and not ( ; )...
May 27 2020 02:29 PM - edited May 27 2020 02:30 PM
SolutionAh, I tried with ( ; ) instead of ( , ) and it worked.
But it's weird, because in here, it has ( , ) and not ( ; )...