View Single Post
  #1   Report Post  
Dennis
 
Posts: n/a
Default Reporting of Empty Cells

I have created a formula that requires reference cells to not report back "0"
unless an entry is made into the cell, including "0". I attempted to use the
#N/A function, but since there are four or more cells that contribute to the
formula, nothing is returned until all cells have received an entry.

The formula I am using is:

=IF(H26=O26,"1",IF(H26O26,"0",IF(H26<O26,"0")))

If the cell is read as "0" for both H26 and O26, the result is "1". What I
need is the result to be "0", until an actual entry is made in H26 & O26
since the entry could be "0" as well as a whole number.

Is there any way to reset the reference cell so that "0" is not read in the
formula unless entered?