Hi!

Not sure of what you're asking but here's some
observations on your formula:

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

"1" and "0" will be treated as TEXT, not numbers. If you
actually mean for those values to be NUMBERS leave out the
quotes. You only want to quote TEXT. (although there are
cases when you just might want numbers as TEXT)

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

This is somewhat contradictory but if it's intentionally
set to be that way you can express that in this manner:

H26<O26

Maybe this is what you're after:

=IF(AND(ISBLANK(H26),ISBLANK(O26)),"",IF(H26<O26, 0,1))

Biff

-----Original Message-----
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?
.