SOLVED

If formula error

Copper Contributor

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.

 

image.png

4 Replies

@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

bhushan_z_0-1590589445973.png

 

@Raiden74 

By the way, is that Excel Online?

@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_0-1590614634918.png

 

 

 

best response confirmed by Raiden74 (Copper Contributor)
Solution

Ah, I tried with ( ; ) instead of ( , ) and it worked.

But it's weird, because in here, it has ( , ) and not ( ; )...

1 best response

Accepted Solutions
best response confirmed by Raiden74 (Copper Contributor)
Solution

Ah, I tried with ( ; ) instead of ( , ) and it worked.

But it's weird, because in here, it has ( , ) and not ( ; )...

View solution in original post