IF FUNCTION DOESNT RECOGNISE THE NUMBER IN A CELL

[likoustefan]

Hi 

I used IF function such as IF(GR19=62,91;"GEORGE";" ") and the function doesn't recognize the number 62,91 in cell GR19

the number 62,91 resulting from another formula. Of course I have already formatting  the cells. Do you have an idea, what happened?

thank you in advance

Lik

[#2]

@likoustefan 

What is the formula in GR19?

[#3]

@likoustefan 

Does this work?

IF(ROUND(GR19;2)=62,91;"GEORGE";"")

[#4]

=IF(BD19=0;GN19)

[#5]

@likoustefan 

If my second reply doesn't help: what does GN19 contain? And so on...

[#6]

please provide a sample file if possible.