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