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.