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.
|