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

Here’s my question:

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

Here is what my situation:

I enter in a number of people every hour into one set of columns. At
the end of the day (on the sheet) I have a total number of people
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 hours
together and divides them by the total amount of people who came in
that day. The result is the Percentage of people who have entered from
for example 8-1.

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

My problem is this. Some rows are left blank for future days. I want
the formula to stay in the cell but it creates a "0" result for the
days that are not filled in. Which the result of that alters the
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" from
a formula just leave the cell blank?


---
Message posted from http://www.ExcelForum.com/

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

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

On Tue, 11 May 2004 19:41:18 -0500, DangerMouse114
wrote:

Here’s my question:

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

Here is what my situation:

I enter in a number of people every hour into one set of columns. At
the end of the day (on the sheet) I have a total number of people
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 hours
together and divides them by the total amount of people who came in
that day. The result is the Percentage of people who have entered from
for example 8-1.

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

My problem is this. Some rows are left blank for future days. I want
the formula to stay in the cell but it creates a "0" result for the
days that are not filled in. Which the result of that alters the
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" from
a formula just leave the cell blank?


---
Message posted from http://www.ExcelForum.com/