# Excel - IF Function Problem - Expert Solution

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
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
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
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
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
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

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.