zero as data value
 

What you say is true, but the solution offered "does" work in many cases, and
there are usually workarounds for odd problems "if" they become a
factor...... I stand corrected tho, for making the statement "the small
number does not materially affect any math done to the numbers"...........

Thanks for pointing it out......

Vaya con Dios
Chuck, CABGx3





"Marvin P. Winterbottom" wrote:

dividing by a very small number (instead of 0) will result in a very large
number which will really look weird. You need to use the IF statement to
check for 0 in division formulas. Also, putting an X instead of 0 will
result in #VALUE! in the cell with the division formula.

"CLR" wrote:

One time I had a similar problem and solved it by using a very small number,
like .00001 instead of a zero. With the proper formatting, the display still
looks like a zero, and the small number does not materially affect any math
done to the numbers...........or, you could always but an X in those cells to
show acknowledgement of "No Production".

hth
Vaya con Dios,
Chuck, CABGx3




"LisaVH" wrote:

I have a spreadsheet I use to track production of a given facility. Some
facility's production is zero. I want to make a distinction between zero
production and a blank cell. Is this possible? I run a conditional format
to tell me when data is missing, however it sees the zero values the same as
a blank cell.