Revision: 12168
                            
                                                            
                                    
                                        
Updated Code
                                    
                                    
                                                    
                        at March 7, 2012 14:51 by jimfred
                            
                            Updated Code
=TREND({0,100},{32,212},70)
In Open Office Calc...
=TREND({0;100};{32;212};70)
                                
                            Revision: 12167
                            
                                                            
                                    
                                        
Initial Code
                                    
                                    
                                                            
                                    
                                        
Initial URL
                                    
                                    
                                                            
                                    
                                        
Initial Description
                                    
                                    
                                                            
                                    
                                        
Initial Title
                                    
                                    
                                                            
                                    
                                        
Initial Tags
                                    
                                    
                                                            
                                    
                                        
Initial Language
                                    
                                    
                                                    
                        at March 4, 2009 14:44 by jimfred
                            
                            Initial Code
=TREND({0,100},{32,212},70)
                                Initial URL
http://www.ozgrid.com/forum/showthread.php?t=69973
Initial Description
This example demonstrates interpolation using Excel's =TREND function by converting 70 degrees F to 21 Celcius.
=TREND({0,100},{32,212},70)
The {..} arrays can of course be replaced with a cell range specifier.
                                Initial Title
Interpolation in Excel using =TREND (interpolate)
Initial Tags
excel
Initial Language
Other