Hi,

I'm trying to predict weight loss at hatching in some eggs I have in an
incubator. It's basically set out as day of incubation in one column and
weight of egg in another. What I'd like, is to ask for the projected weight
on a specific day in the future (always the same day). However, I want to be
able to keep entering data (say I've reached day 3 now, so I'd like to enter
day 4 tomorrow etc), so I need the formula to include empty cells (o I don't
have to change it every time I enter new data). This doesn't seem to be
working, I think the formula is including missing values as 0, which messes
up the calculation. The missing values are before the first values as well as
after.

Is there a way of getting excel to ignore the cells with missing values? I
should also mention that there are 8 eggs at the moment, and there will be
lots more. Id like to just create this formula once and for all, and just
drag it to wherever I need it.

Thanks for reading this. I hope one of you has a good solution to what I'm
sure is an easy problem to solve, right?

Regards

�sa

maybe try FORECAST instead, this ignores blanks and text values.

"Asa_johannesen" wrote:

Hi,

I'm trying to predict weight loss at hatching in some eggs I have in an
incubator. It's basically set out as day of incubation in one column and
weight of egg in another. What I'd like, is to ask for the projected weight
on a specific day in the future (always the same day). However, I want to be
able to keep entering data (say I've reached day 3 now, so I'd like to enter
day 4 tomorrow etc), so I need the formula to include empty cells (o I don't
have to change it every time I enter new data). This doesn't seem to be
working, I think the formula is including missing values as 0, which messes
up the calculation. The missing values are before the first values as well as
after.

Is there a way of getting excel to ignore the cells with missing values? I
should also mention that there are 8 eggs at the moment, and there will be
lots more. Id like to just create this formula once and for all, and just
drag it to wherever I need it.

Thanks for reading this. I hope one of you has a good solution to what I'm
sure is an easy problem to solve, right?

Regards

�sa

Hi Lori,

Thanks for the reply. I'm afraid it doesn't solve my problem, as FORECAST
seems to only ignore blanks when both x and y are blank. I'd like to keep the
values in the x column, as not all the eggs are at the same stage of
incubation (i.e. I can't just include up to day 3 and then add 4 when I weigh
the eggs tonight, as some eggs are on day 2 and others on day 6). If I were
to type in both x and y value at each weighing, that would involve having 8
identical columns with the only difference being how many values are in each.

Thanks again

�sa

"Lori" skrev:

maybe try FORECAST instead, this ignores blanks and text values.

"Asa_johannesen" wrote:

Hi,

I'm trying to predict weight loss at hatching in some eggs I have in an
incubator. It's basically set out as day of incubation in one column and
weight of egg in another. What I'd like, is to ask for the projected weight
on a specific day in the future (always the same day). However, I want to be
able to keep entering data (say I've reached day 3 now, so I'd like to enter
day 4 tomorrow etc), so I need the formula to include empty cells (o I don't
have to change it every time I enter new data). This doesn't seem to be
working, I think the formula is including missing values as 0, which messes
up the calculation. The missing values are before the first values as well as
after.

Is there a way of getting excel to ignore the cells with missing values? I
should also mention that there are 8 eggs at the moment, and there will be
lots more. Id like to just create this formula once and for all, and just
drag it to wherever I need it.

Thanks for reading this. I hope one of you has a good solution to what I'm
sure is an easy problem to solve, right?

Regards

�sa