When I enter a dot in the formula it displays the formula

[toony]

When I enter the below formula it displays and works fine
=IF(AND(AP1804>1,AJ1804=""),"1",IF(ISBLANK(AP1804),"",COUNTIF(AJ$139:AJ1804,AJ1804)))


But as soon as I enter “.” in the first brackets, it just displays the whole formula, not the value

=IF(AND(AP1804>1,AJ1804="."),"1",IF(ISBLANK(AP1804),"",COUNTIF(AJ$139:AJ1804,AJ1804)))

Any ideas why could it be?

[NBVC]

Obviously that shouldn't happen. Make sure that your cell format is not TEXT before entering the formula.

[toony]

Cool. Will check it. Thank you