Maybe,

=IF(ISNUMBER(O188),IF(O188=$E188,1,0),0)

Mike

"carl" wrote:

I would like this formula to work only if the value in O188 is a number. If
it is not a number, return 0 (zero).

=IF(O188=$E188;1;0)

Thank you in advance.