D
DangerMouse114
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?
(e-mail address removed)
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?
(e-mail address removed)