automatic linear interpolation: is there a function in excel?

[stadamack]

Electricity meter readings are recorded every 7 days and recorded in an excel spreadsheet. Date is recorded in Col 1. Corresponding meter reading is recorded in Col 2. From the data entered I would like to automatically calculate the consumption for each month. is there a function in excel to a date (in the range cotained in col 1) and the array containing data in col 1 and col 2 and return the corresponding meter reading? Automatic linear interpolation.

 

[jbenson001]

This is not a SQL Server programming question. There maybe another forum for you to post in.

 

[SkipVought]

Hi,

Check out the TREND function.

Also related: LINEST, Tred, SLOPE

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

oope...

also
LINEST, TREND, SLOPE

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jbenson001]

Try this forum:
forum68