Modify A Formula
 

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.

Modify A Formula
 

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.

Modify A Formula
 

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

Note that arguments are separated by commas, not semicolons.

Tyro

"carl" wrote in message
...
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.

Modify A Formula
 

=IF(AND(ISNUMBER(O188);O188=$E188);O188;0)

On 23 Mar, 20:20, 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.

Modify A Formula
 

Note that arguments are separated by commas, not semicolons

Depends on where you live and what your regional settings are.


--
Biff
Microsoft Excel MVP


"Tyro" wrote in message
...
=IF(ISNUMBER(O188),IF(O188=$E188,1,0),0)

Note that arguments are separated by commas, not semicolons.

Tyro

"carl" wrote in message
...
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.

Modify A Formula
 

Another one:

=COUNT(O188)*(O188=E188)

You also might want to test E188 as well:

=(COUNT(E188,O188)=2)*(O188=E188)


--
Biff
Microsoft Excel MVP


"carl" wrote in message
...
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.