Forum Discussion

marijana820's avatar
marijana820
Copper Contributor
Dec 17, 2021

if problem

Hi...I have a PROBLEM with this formula.I tried to figure out were is the problem,but couldn't fix it.I done this as a teacher from youtube,but for me not working.Sorry for Excel language
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 17, 2021

marijana820 I suspect that IF is not recognised by your localised Excel version, and perhaps the commas need to be replaced by semi-colons. Have a look at the attached file. It will translate to your locale automatically.

 

marijana820's avatar
marijana820
Copper Contributor
Dec 17, 2021
Yeah it's very confusing.I've tried with attached file,but still the same.And in this version of Excel should use commas

Resources