Zeros and #DIV/0!
#DIV/0 can be cleaned up by changing the formula to check for a zero
denominator.
=if(C2=0, "", B2/C2)
As for the zeros there are a couple of options. One is to not show any zero
values on the sheet by selecting Tools - Options - View tab and uncheck
Zero Values. The other option is to hide the zero's with condtional
formatting. Select the cell range and then Format - Conditional Formatting
- Cell Value is = 0 and format the text to be the same colour as the
background (usually white)...
--
HTH...
Jim Thomlinson
"JD" wrote:
In a cell I have formula that uses data from other cells to calculate values.
Before data is entered into those cells I always see either zeros or #DIV/0!
on my spreadsheet. How do fix it so the cell with the formula is empty until
I enter corresponding data in the other cells?
thanks
--
JD
|