Conditional Statement
If you're getting a #VALUE! error when A7 and/or B7 "appear" to be empty
then those cells are not empty. If both cells were empty the result of the
formula would be 0.
Do those cells contain formulas that might return formula blanks?
=IF(C7=9999,0,IF(COUNT(A7:B7)=2,(B7-A7)*24,0))
--
Biff
Microsoft Excel MVP
"regdor" wrote in message
...
I am working with a spreadsheet that uses the conditional statement as
follows:
=IF(C7=9999,0,(+B7-A7)*24). The forumla works fine when B7 and A7 have
data
in them, however when the formula references cells that don't contain any
data I get a #value error. How can i get the same results from the
formula
and not get the error message. Thanks.
|