zero values

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

Hi, I was wondering if anybody could help me with a problem I am having
I have a worksheet with several formulas in it where different user
input information. Since it is a worksheet for the whole year I hav
up to the month of december, in which case some of the formulas displa
'0'. I went to options and unchecked the '0' box, however, now, if th
user inputs '0' it also does not show. Is there a way to show the '0'
the users in put but not the '0' zeros for the formulas. Many Thanks.

Marco
 
Marcos, there are two possible solutions:

(1) you can place your formulas in IF statements where if they equal zero,
nothing will display, like so:

=IF([my formula]=0,"",[my formula])

(2) you can place your formula in an IF statement that says if some cell
that the formula depends on is blank, nothing will display in the formula
cell (this is the better solution, by the way):

=IF(ISBLANK([some cell that my formula depends on for input]),"",[my
formula])

Of course, in no case do you put in the square brackets [].

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 
Back
Top