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

Question

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

Answer 1

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

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

Submit an answer

related questions