Interpolation in excel

[Einsener37]

Hi!
I have table 4.1, where it is given ϕc values for certain range.
Now i have values between given values, N_Ed,1/N_Ed=0.6 and l₀/h=13.1.
Is there a way to use Excel interpolation and related functions to find ϕc for these values?

[June7]

So would you expect to return 0.82 with those inputs?

Review https://www.mrexcel.com/excel-tips/u...ingle-formula/

[arnelgp]

you give the "magic" formula to arrived at those values.
because i noted that 0.5 and 1.0 has same values (6-10).
and 1 has somewhat "irregular" values from 12 up.

[p45cal]

The link given by June7 has a long formula to solve this one - I was wondering whether there was a shorter formula to calculate the values directly.
Einsener37, could you point to us what these values are and how they might be derived?

[Aussiebear]

0.6 values: 0.92, 0.91, 0.90, 0.88, 0.85, 0.81, 0.76, 0.70.

Interpolation formula = (End-Start)/(Row(End)-Row(Start)) Where End = Max Value and Start = Min Value

In the attached spreadsheet I have expanded the data provided Rows 3 (Max Value), 8 (Half Value), & 13 (Min Value) hence we need to determine the values for rows 4 to 7, & 9 to 12. in the initial table. The second table shows the interpolated values