Formula Guidance
 

I have a quick question... I mostly need you to point me in the right
direction, then I'll take it from there. I have a formula that is calculated
by using two numbers. One of the numbers changes every week. I don't want
to go in and edit my formula each week for like 50 cells, I'd rather just
make the formula automatically use the new number for the calculation.

Basically, imagine a goal of 55 sales in a1 (the constant number), and each
week I'll put in how many sales were achieved. At the end of the row, I'll
have a percentage calculating how close was actually achieved based on the
initial goal. I just need to know how to make that percentage cell
automatically read the new week as the new variable.

Is there a way to do this?

Formula Guidance
 

If the week amount gets added onto a column, use something like

=INDEX(A:A,MATCH(9.99999999999999E307,A:A))

to get the last value in column A

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Falcon" wrote in message
...
I have a quick question... I mostly need you to point me in the right
direction, then I'll take it from there. I have a formula that is
calculated
by using two numbers. One of the numbers changes every week. I don't
want
to go in and edit my formula each week for like 50 cells, I'd rather just
make the formula automatically use the new number for the calculation.

Basically, imagine a goal of 55 sales in a1 (the constant number), and
each
week I'll put in how many sales were achieved. At the end of the row,
I'll
have a percentage calculating how close was actually achieved based on the
initial goal. I just need to know how to make that percentage cell
automatically read the new week as the new variable.

Is there a way to do this?