Can I make a formula that has the result of "0" remain empty?

[DangerMouse114]

Here’s my question:

Is there away to make a result of "0" from a formula just leave th
cell blank?

Here is what my situation:

I enter in a number of people every hour into one set of columns. A
the end of the day (on the sheet) I have a total number of peopl
who’ve walked in.

Example:

8-9 | 9-10 | 10-11 | 11-12 | 12-1 | 1-2 | 2-3 | 3-4 | 4-5 | Total
_5 _|_ 10 _|_ 15 _ | _ 25 _ | _ 30 |_ 35 | 25 | _ 20 |
5 | 170

Ok so with that information the second part of my sheet adds 3 hour
together and divides them by the total amount of people who came i
that day. The result is the Percentage of people who have entered fro
for example 8-1.

Every row is another day. After about 10 rows the bottom figures th
average of all the amounts to give you the average percent of traffi
for each section of hours.

My problem is this. Some rows are left blank for future days. I wan
the formula to stay in the cell but it creates a "0" result for th
days that are not filled in. Which the result of that alters th
percentages at the bottom of the work sheet. (I.e. 100, 150, 125, 0
0, 0, makes the average 62.5 not 125)

So to re- state my question. Is there away to make a result of "0" fro
a formula just leave the cell blank

 

[tjtjjtjt]

Yes, you can do make the cell display "0." You need to remember that it will have the formula in it, though, so technically, it won't be empty
Use the IF Function. Here's the syntax you'll need
=IF(your_formula=0,0,your_formula

tj

 

[Gord Dibben]

Mouse

Since you didn't post any formulas it is difficult to know what you should do.

Example of changing a zero to a blank.....

Assume you have column A with some cells filled with numbers and some cells
with nothing.

In B1 enter =A1 If A1 has no value, you will get a zero in B1.

=IF(A1="","",A1) entered in B1 would return a number if A1 has a value and
return a blank if no value.

=IF(A1=0,"",A1) would do the same.

Perhaps your formulas could be altered in a similar manner?

Gord Dibben Excel MVP

 

[tjtjjtjt]

Should've been: =IF(your_formula=0,"",your_formula

t
----- tjtjjtjt wrote: ----

Yes, you can do make the cell display "0." You need to remember that it will have the formula in it, though, so technically, it won't be empty
Use the IF Function. Here's the syntax you'll need
=IF(your_formula=0,0,your_formula

tj