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)
 

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

How to count the maximum number flanked by zeros 9
Adding recognised Zeros 5
Average formula works but.... 3
Modify a Formula 4
With F1 value, look at A, if match or partial match return B 5
Formula (or code) return the largest number of duplicates in a list. 16
Excel Need Countifs Formula Help 0
IF AND Nested Functions - Formula Not Working 0

Back
Top