Excel Help (Interpolation)

[Aero]

Hey people!

I kind of need some help with a formula I'm trying to put together for a spreadsheet but I am having some difficulty with it.

The basic problem is this, I have a table (below) which I need to interpolate the vales from but I am unsure as to how to do it in excel.

Aspect Ratio | 1.00 | 1.6 | 3.00 | 5.5 | 7.5 | 13.5 | 20 | 30 |
Force Coeff | 1.26 | 1.3 | 1.35 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 |

Thats the basic table (I hope it displays ok)

I was trying to make it work using the IF function but that wasn't working out well any advice people as I'm really quite stuck on this!!!

Potential reward if you can sort it out

Aero

 

[Aero]

Sorry i didn't really clarify that, its a linear interpolation e.g. If I had a value for the aspect ratio of 1.3 the force coefficient would be 1.28.

Its for wind loading on a sign (exciting stuff I know!)

Thanks for any help

Aero

 

[Aero]

I realise that there isn't a simple why to sort this but I do need it in excel the interpolation actually isn't a problem for me but I am trying to design a spreadsheet that will perform a number of calculations and this is just 1 in a step of about 30.

 

[Aero]

Hey guys thanks for the effort I have now sorted it by using the Vlookup and basically writing out all the values of the table to 2 decimal places.

Thanks a lot!

Aero