# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

if i draw a line with 3 point of mine , how can i make a table of values of many other points of the same line ?
Solved by G. U. in 27 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/06/2018 - 04:28
Hello
User 10/06/2018 - 04:28
hi
User 10/06/2018 - 04:28
it my first time here
User 10/06/2018 - 04:29
Excelchat Expert 10/06/2018 - 04:29
Yes of course
User 10/06/2018 - 04:29
if i draw something here it show on ur screen ?
User 10/06/2018 - 04:29
or i just tell u
Excelchat Expert 10/06/2018 - 04:30
You can draw at the fiew
Excelchat Expert 10/06/2018 - 04:30
view *
Excelchat Expert 10/06/2018 - 04:30
Or if you have an excel file you can attach it
User 10/06/2018 - 04:30
ok
User 10/06/2018 - 04:31
iif i draw a line with 3 points of mine
User 10/06/2018 - 04:31
and i want to extract many other point and put in on a table
User 10/06/2018 - 04:31
table
Excelchat Expert 10/06/2018 - 04:32
Ok
User 10/06/2018 - 04:32
how i extract them from gragh
Excelchat Expert 10/06/2018 - 04:33
if you draw a line form points, you can generate the equation of the line and make infinite number of points
User 10/06/2018 - 04:34
so i must get out the equation and put it into a cell and calculate ?
User 10/06/2018 - 04:34
did u see what i have draw now ?
Excelchat Expert 10/06/2018 - 04:34
Yes I see
Excelchat Expert 10/06/2018 - 04:35
yes you need equation for this
User 10/06/2018 - 04:35
yes do see the x axis
User 10/06/2018 - 04:35
its a date
Excelchat Expert 10/06/2018 - 04:35
Excel can generate this equation
Excelchat Expert 10/06/2018 - 04:35
yes
Excelchat Expert 10/06/2018 - 04:36
excel deal the date as a numbers
User 10/06/2018 - 04:36
i want to make a table but by days do u understand me
User 10/06/2018 - 04:36
i want calculate y when x = 60 day
User 10/06/2018 - 04:36
180
User 10/06/2018 - 04:37
and like that
User 10/06/2018 - 04:37
how i transform it
Excelchat Expert 10/06/2018 - 04:37
So change the Column B to be by dates
Excelchat Expert 10/06/2018 - 04:37
by days*
User 10/06/2018 - 04:38
aha i understood
User 10/06/2018 - 04:39
and generate equation and take points i need
Excelchat Expert 10/06/2018 - 04:39
Yes
Excelchat Expert 10/06/2018 - 04:39
Also you can make the equation with the dates
Excelchat Expert 10/06/2018 - 04:40
Look to the yellow cell at I16
User 10/06/2018 - 04:40
yes
Excelchat Expert 10/06/2018 - 04:40
it contain date
Excelchat Expert 10/06/2018 - 04:41
but if you change the format as number it show number of dates for that date
User 10/06/2018 - 04:42
42941 what is that number refer to
User 10/06/2018 - 04:42
or its random
Excelchat Expert 10/06/2018 - 04:43
no it is the number of days form year 1900
User 10/06/2018 - 04:43
aha i see
User 10/06/2018 - 04:43
can i make it form specific date ?
Excelchat Expert 10/06/2018 - 04:44
for example At J18 the date is 12/31/1899
User 10/06/2018 - 04:44
from 1/1/2008 for example
Excelchat Expert 10/06/2018 - 04:44
Which is the number 1
Excelchat Expert 10/06/2018 - 04:44
Yes
User 10/06/2018 - 04:44
i want make there refernce not 1900
User 10/06/2018 - 04:44
i want make it 2008 can i do that ?
User 10/06/2018 - 04:44
and how
Excelchat Expert 10/06/2018 - 04:45
by subtraction
User 10/06/2018 - 04:45
can u do it
Excelchat Expert 10/06/2018 - 04:46
Can you return the dates at B
User 10/06/2018 - 04:46
like that
Excelchat Expert 10/06/2018 - 04:46
Yes
Excelchat Expert 10/06/2018 - 04:47
At B I'll calculate the days form 1/1/2008
User 10/06/2018 - 04:47
make it from 3/1/2008
User 10/06/2018 - 04:47
the first date
User 10/06/2018 - 04:47
1/3
User 10/06/2018 - 04:47
sorry
Excelchat Expert 10/06/2018 - 04:48
Ok
Excelchat Expert 10/06/2018 - 04:48
Look at col A
User 10/06/2018 - 04:48
yes
Excelchat Expert 10/06/2018 - 04:48
It is the difference between the two dates
User 10/06/2018 - 04:48
aha
User 10/06/2018 - 04:49
just i subtract
User 10/06/2018 - 04:49
and value turnt into number it self
User 10/06/2018 - 04:50
u there?
User 10/06/2018 - 04:55
ok thank u too much for ur time

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.