Fill in missing data

**crobledo** · 05-31-2013, 12:34 PM

GPM.xlsx GPM.xlsxi have a table with presures at 10,15,20,25,30,40,60,80,10,150,200,300,400 and underneath there is the gallos per minute at that pressure with using a disk with a 0.031 diameter. is there a formula that can calcutate the rest of the Gallons per minute for all of the other pressures between 10-400? i ve made a curve graph but that wont actually give me the data i need.

any ideas?

**dilipandey** · 05-31-2013, 12:51 PM

HI crobledo,

Suggest you to upload a sample workbook to support your query.

Regards,
DILIPandey
<click on below * if this helps>

**crobledo** · 05-31-2013, 01:19 PM

here it is

**dilipandey** · 05-31-2013, 01:53 PM

Okay.. you can use Forecast function here:-

Formula:

Please Login or Register  to view this content.

GPM.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**crobledo** · 05-31-2013, 02:39 PM

thanks but i have a question. if i type 125 it does give me a number but if i type for somthing i already have solved for on the table why is the number different than what i already have on there? i typed in 150 ans it gave me .104 instead of .0115.
im actually building a callibration program to spray chemicals and the numbers have to be correct if its wrong they might callibrate something wrong and cause damage.

**crobledo** · 05-31-2013, 02:40 PM

thanks but i have a question. if i type 125 it does give me a number but if i type for somthing i already have solved for on the table why is the number different than what i already have on there? i typed in 150 ans it gave me .104 instead of .0115.
im actually building a callibration program to spray chemicals and the numbers have to be correct if its wrong they might callibrate something wrong and cause damage.

**dilipandey** · 06-04-2013, 08:30 AM

Hi crobledo,

I would suggest you to read the excel's inbuilt help to understand Forecast function and then you can check if using this function will work in your case.

Regards,
DILIPandey
<click on below * if this helps>