Modify A Formula

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

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.
 
=IF(ISNUMBER(O188),IF(O188>=$E188,1,0),0)

Note that arguments are separated by commas, not semicolons.

Tyro
 
Note that arguments are separated by commas, not semicolons

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

=COUNT(O188)*(O188>=E188)

You also might want to test E188 as well:

=(COUNT(E188,O188)=2)*(O188>=E188)
 
Back
Top