Forum Discussion
Solved
IF Function not working on desktop app but OK online
I've been using excel on and off for over 20 years. My problem is that a simple IF statement works online but not on my desktop app. =IF(C4=C5, "True", "False") was created online without errors ...
Thank you. Point is not a good choice for the List separator. I'd set it to semicolon ;
You can then use ; between the arguments of a formula:
=IF(C4=C5; "True"; "False")
Thank you. Point is not a good choice for the List separator. I'd set it to semicolon ;
You can then use ; between the arguments of a formula:
=IF(C4=C5; "True"; "False")
- I was just working with that as you replied. Yes setting the List Separator to ; has solved the problem.
Thank you for your time .