Last answered:

09 Mar 2023

Posted on:

08 Mar 2023

0

Resolved: "There is a problem with this formula" error message

Hi there, 

I am trying to exercise the IF function on the spreadsheet which I donwloaded from the resources, however I get a "There is a problem with this formula" error message with some guidance, as if I am not using a formula. 


Could that be due to the formating of the cells on the spreadsheet?

Your advice will be approiciated. 


Hristo


1 answers ( 1 marked as helpful)
Instructor
Posted on:

09 Mar 2023

2

Hi Hristo,

Good to hear from you,

I think the issue might be that you are using semicolon (;) instead of comma (,) as arguments separator in the function. Depending on your language settings your Excel might work with ; or ,

Please try that.

Best,

Ned   

Submit an answer