FUNCTION FOR LINEAR INTERPOLATION 5

[nitin36537]

IS THERE ANY FUNCTION FOR LINEAR INTERPOLATON IN EXCEL?

I HAVE A TABLE FOR WIND PRESSURE ON TOWER STUCTURE IN EXCEL LIKE THIS

A B C
1 200 400 <----- SPAN
2 20 10 20
3 30 40 60

RAW 1 INDICATE SPAN
COLUMN A INDICATE HEIGHT OF STRUCTURE
RANGE A2:C3 INDICATE WIND PRESSURE

I HAVE TO FIND OUT WIND PRESSURE ON TOWER WITH SPAN OF 300 METER AND HEIGHT OF 25 M

FUNCTION SHOULD RETURN WIND PRESSURE = 32.5

CAN ANY BODY HELP?

I HAVE SOLVED THIS BY DEVELOPING CUSTOM FUNCTION.
IS THERE ANY BUILT IN EXCEL FUNCTION FOR INTERPOLATION?

IF ANY BODY LIKE TO SEE MY CUSTOME FUNCTION PLEASE ASK.


NITIN PATEL

INDIA

 

[svanels]

Sounds strange importing from one spreadsheet package to another.
If you want to export, use some real computing power from MathCad or MathLab

Regards Steven van Els
SAvanEls@cq-link.sr

 

[imtiyaz]

hi mala,
great work, your formula just saved me. thanks to nitin also for posting good question.
great work guys.
regrads,
imtiyaz