Question description:
This user has given permission to use the problem statement for this
blog.
I know how to make a forumal change weekly with fixed numbers but how do you make it change with numbers that change weekly? For example: =8*'sheetname'!$A$1
What if the 8 wasn't the same every week?
Solved by Z. U. in 28 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/03/2018 - 09:15
Hi welcome to Gotit
Excelchat Expert
08/03/2018 - 09:15
hello
Excelchat Expert
08/03/2018 - 09:16
please share your sheet
User
08/03/2018 - 09:16
I have a spreadsheet that reads formulas week to week for fixed goals....I want to use a similar formula for actual production week to week as well
User
08/03/2018 - 09:16
I dont have a sheet yet
Excelchat Expert
08/03/2018 - 09:17
Please provide example data
User
08/03/2018 - 09:19
Calls needed will be the same every week....100
User
08/03/2018 - 09:19
Calls made will change every week...25
Excelchat Expert
08/03/2018 - 09:19
ok
User
08/03/2018 - 09:19
How do I keep a running tally of E10 week to week
Excelchat Expert
08/03/2018 - 09:20
you need E10 value of every week?
User
08/03/2018 - 09:20
without manually doing it
User
08/03/2018 - 09:20
yes but I need c10 to constantly add 100 each week and not include weeks that havent occurred yet
Excelchat Expert
08/03/2018 - 09:20
Here we can write a formula for individual weeks
Excelchat Expert
08/03/2018 - 09:21
So you can compare individual week percentages
Excelchat Expert
08/03/2018 - 09:21
See E3 and E5
User
08/03/2018 - 09:22
i see that..understand that
Excelchat Expert
08/03/2018 - 09:22
so you can have a look on individual weeks
User
08/03/2018 - 09:23
how do I make c10 and d10 automatically include new weeks without adding weeks that have not occured yet
Excelchat Expert
08/03/2018 - 09:23
E10 is basically gives you average of week 2 and 3
User
08/03/2018 - 09:23
i dont want 3/15 added yet but I will when 3/16 day is here
Excelchat Expert
08/03/2018 - 09:24
I didn't get you
User
08/03/2018 - 09:24
c7 and c8
Excelchat Expert
08/03/2018 - 09:24
yes
User
08/03/2018 - 09:24
those dates havent happened yet but I know what the goal is
User
08/03/2018 - 09:24
when 3/17 is here how does c10 automatically calculate c7 and c8 now that they are in the past
User
08/03/2018 - 09:25
so on 3/18 c10 should be 400
Excelchat Expert
08/03/2018 - 09:26
So C10 should automaticall calculate the added weeks right
Excelchat Expert
08/03/2018 - 09:26
that is what you are saying?
User
08/03/2018 - 09:26
but only for the data that is int eh past
User
08/03/2018 - 09:26
is in the past
User
08/03/2018 - 09:27
i currently have to go into c10 and add c7 and c8 manually for all individuals
Excelchat Expert
08/03/2018 - 09:27
C10 should calculate only past data not future
User
08/03/2018 - 09:27
how do you do that?
User
08/03/2018 - 09:27
c10 currently has 400
User
08/03/2018 - 09:27
shold read 200
Excelchat Expert
08/03/2018 - 09:28
So you want only past data not future data to be added right?
User
08/03/2018 - 09:28
yes
Excelchat Expert
08/03/2018 - 09:29
Give me 5 minutes
Excelchat Expert
08/03/2018 - 09:34
Please check now
Excelchat Expert
08/03/2018 - 09:35
I added formula C3 to C9 and check how E10 changes
Excelchat Expert
08/03/2018 - 09:35
hello
Excelchat Expert
08/03/2018 - 09:35
are you there?
Excelchat Expert
08/03/2018 - 09:35
Hey
User
08/03/2018 - 09:35
yes
Excelchat Expert
08/03/2018 - 09:35
Are you there?
Excelchat Expert
08/03/2018 - 09:35
Please check
User
08/03/2018 - 09:35
what is that? lol
Excelchat Expert
08/03/2018 - 09:36
Change 16 mar to past date
User
08/03/2018 - 09:36
yes!!
Excelchat Expert
08/03/2018 - 09:36
E10 changed right?
Excelchat Expert
08/03/2018 - 09:36
Change it to future date
Excelchat Expert
08/03/2018 - 09:36
and check
User
08/03/2018 - 09:36
yes...how?
Excelchat Expert
08/03/2018 - 09:36
is that working?
User
08/03/2018 - 09:37
that is what I need
Excelchat Expert
08/03/2018 - 09:37
In F1 you can see today formula right?
User
08/03/2018 - 09:37
so just change f1?
Excelchat Expert
08/03/2018 - 09:37
no
Excelchat Expert
08/03/2018 - 09:37
in B10 I wrote a formula
User
08/03/2018 - 09:38
I see the formula...what is the < referncing?
Excelchat Expert
08/03/2018 - 09:38
it will compare the dates with today and add if date is less than are equal to today
Excelchat Expert
08/03/2018 - 09:39
because future days will be greater than todays
User
08/03/2018 - 09:39
how does it know current date?
Excelchat Expert
08/03/2018 - 09:39
Got the logic which I used?
Excelchat Expert
08/03/2018 - 09:39
F1 is have a function called today
Excelchat Expert
08/03/2018 - 09:39
today will return current date
User
08/03/2018 - 09:39
F1 = today?
Excelchat Expert
08/03/2018 - 09:39
yes
User
08/03/2018 - 09:39
shoot...didnt know that!
Excelchat Expert
08/03/2018 - 09:40
Go to F1 cell
Excelchat Expert
08/03/2018 - 09:40
you will see a fucntion =Today() which will return current date
Excelchat Expert
08/03/2018 - 09:40
Gotit ?
User
08/03/2018 - 09:40
that is confusing
User
08/03/2018 - 09:41
I think I get it
User
08/03/2018 - 09:41
put what I have to put back in f1
Excelchat Expert
08/03/2018 - 09:41
=Today()
User
08/03/2018 - 09:42
so it autmotically puts next day
Excelchat Expert
08/03/2018 - 09:42
yeah tomorrow it changes to 10 automatically
Excelchat Expert
08/03/2018 - 09:42
Note I made formula only for calls need column
Excelchat Expert
08/03/2018 - 09:43
Make changes for other cells using the same formula
Excelchat Expert
08/03/2018 - 09:43
and please end the session
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.