Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
How to do a Linear interpolation in excel? | Excel Worksheet Functions | |||
linear interpolation function in excel | Excel Worksheet Functions | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) | |||
interpolation in excel | Excel Worksheet Functions |