Forum Discussion
IF Function not working on desktop app but OK online
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")
Detlef_Lewin thanks for a quick reply. I have tried ; and . and , this is driving me crazy.
if I download the file created online and open it on the desktop app it functions correctly , if I try and edit the formula it errors with the same message as before.
Press the Windows key+R to activate the Run dialog.
Type control international and press Enter or click OK.
Click Additional settings...
What is the List separator?
Activate the Currency tab.
What are the Decimal symbol and the Digit grouping symbol?
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 .