Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 515
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 515
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Charts and Charting in Excel 15 June 2nd 09 10:53 AM
How to do a Linear interpolation in excel? Ines Excel Worksheet Functions 1 May 17th 07 07:10 PM
linear interpolation function in excel tskoglund Excel Worksheet Functions 4 September 10th 05 03:31 AM
help with interpolation and limit of interpolation uriel78 Excel Discussion (Misc queries) 0 February 17th 05 04:27 PM
interpolation in excel Elif Excel Worksheet Functions 2 January 7th 05 10:12 AM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"