Tag Archives: defined names

Alternative IP and Rotations

Posted on 11/04/2011 by dougaj4

In response to the 3D Intersections and PView Function posts Lori Miller has sent me two very elegant alternative ways of achieving similar results. The first is an on-spreadsheet solution to the intersection of two lines, using the LinEst function: Note … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Excel | Tagged , , , | Leave a comment

Charting a Mathematical Function with Defined Names

Posted on 15/12/2010 by dougaj4

This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu.  To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading →

Posted in Arrays, Charts, Excel, Maths | Tagged , , , , | 7 Comments