Displaying cell contents
The easiest way will be by de-selection 'Zero values' - in Tools Options
View tab.
The longest way will be by using an IF statement which checks the condition.
It should read something like:
=IF(<calculation=0,"",<calculation)
Micky
"BlueAngel" wrote:
I have a spreadsheet that has a formula in it in cells C1:J50. The cells are
displaying 0 because there is nothing to calculate. How can I keep my
formula for calculating when actual numbers are entered but the display will
show an empty cell, not 0.
Thanks,
Blue Angel
|