Various Interpolation types in Excel

M

Mohamed Badawy

I'm trying to perform several types of interpolation similar to that of matlab:

1- Linear Interpolation
2- Linear Spline
3- Cubic Spline

Anyone can guide me to any documents to read or if any exists an Excel Add-in.
Please note I'm using Office-2003.

Thanks
 
K

Kassie

Your info is ectremely limited, but yes, it can be done. Have you looked at
Conditional Formatting yet?

Say the one value is in B2, and the other value is in C2, then select the
all used cells in row 2, click on the Formatting menu on top, select
conditional formatting, change the Cell Value Is block to Formula is, and
type in B2=C2. Click on the Format button, select the Pattern tab, and set
the colour of your choice.

Alternatively, if you have Excel 2007, click on the conditional formatting
button, select the Hoghlight cells option, select Equal to, and enter =$C$2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top