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

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Obviously that shouldn't happen. Make sure that your cell format is not TEXT before entering the formula.
 

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
Cool. Will check it. Thank you
 
Top