need to test existence of a value in a cell

P

Paul M

This is probably simple, but I can't find it anywhere.
Please look.

=IF(E9>0,(F9-E9),0)

I need my conditional statement to test for the EXISTENCE
of a number (instead of E9>0 - I need to allow '0' now),
but if there is no value I need to assign '0' to the cell
the IF statement is in. I have to have a valid number in
that cell or it will screw up other formulas on the page.

The other alternative would be to get a SUM formula to
ignore any invalid formulas, but the other seemed like
the easier thing to do. Thanks!
 
H

Harald Staff

Hi

Existance of a number, any number:
=IF(ISNUMBER(A1),...

Empty cell or not:
=IF(A1<>"", ...
 

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

VBA Export to PDF 0
SUMIF with OFFSET 5
How can I test the text content of a cell 4
SUM cells with blank value 11
IF(AND with date comparison 4
Help with IF Function 3
Testing a cell value for a specific weekday. 4
Count Number of Unique Cells That Don't Have Certain Characters 0

Top