toony
New member
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?
=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?