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