Modify A Formula


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

Advertisements

T

Tyro

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

Note that arguments are separated by commas, not semicolons.

Tyro
 
T

T. Valko

Note that arguments are separated by commas, not semicolons

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

Advertisements

T

T. Valko

Another one:

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

You also might want to test E188 as well:

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify A formula 1
Modify a Formula 4
Modify Formula 2
Modifying A Formula 12
Modify a Formula 1
Modify A Formula 2
Modify a Formula 2
Modify Formula 2

Top