Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |