Various Interpolation types in Excel
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 |
Various Interpolation types in Excel
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 -- Hth Kassie Kasselman Change xxx to hotmail "Mohamed Badawy" wrote: 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 |
Various Interpolation types in Excel
So sorry, this ended up with the wrong question, please ignore!
-- Hth Kassie Kasselman Change xxx to hotmail "Kassie" wrote: 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 -- Hth Kassie Kasselman Change xxx to hotmail "Mohamed Badawy" wrote: 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 |
All times are GMT +1. The time now is 04:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com