If Formula not working

[SemperFi]

Hi
Hoping you can bring some light into this issue.

Every time I write an IF statement into my Excel, I always get an error, regardless if the formula is as simple as the sample, or as complicated as it can get, the outcome is always the same. I am using the last version of Office 365. Any Clue as what I'm doing wrong? Thank you this is driving me nuts!

 

[SemperFi]

It is the same formula, just using different Regional Settings.
It never occurred to me, because using commas (and not semi-colons) as formula argument separates is the default for American versions of Excel.
Looking at your logo, it never occurred to me that you might not be using an American version of Excel (or at least not using default American version settings!)

If you are not comfortable subbing out semi-colons instead of commas in your formulas for future questions, you may want to mention that fact in your posts.

I was not even aware this was a different regional settings, it's a work computer with Cargill's own license. I'll bring this up to my IT department, although they were a dumb as a door nub when trying to help me, couldn't even understand the initial question that I had to formulate 5 times before coming to this forum and have you guys figure it out in a flash.

Again, thank you very much for your assistance, I truly appreciate your help and thanks to you now I know something new to my setup.

Semper Fi