Obviously that shouldn't happen. Make sure that your cell format is not TEXT before entering the formula.
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?
Obviously that shouldn't happen. Make sure that your cell format is not TEXT before entering the formula.
Cool. Will check it. Thank you
Bookmarks