Formula Help

Highlighted
Occasional Visitor

Hi, I am trying do input some formula in exel mac. I always get a problem. I am following video on youtube where this formula works but when i do it it does not work. I am doing all the same as in the youtube video, using the same rows and colums. This is the formula: =IF(AND(F5>=D6,F5<=E6),"X","")

 

 what can i do to make it work, i always get the answear that there is a problem with this formula?

I will put a screen shot of the formula from the youtube video so you can see i am doing the same formula....

1 Reply
Highlighted

As variant. This formula is for English (I guess USA) locale and English language. If you in another locale it could looks differently (semicolons instead of commas), for other languages that will be local variant of the formula.