Insights Blog
-- Browse All Articles --
Physics Articles
Physics Tutorials
Physics Guides
Physics FAQ
Math Articles
Math Tutorials
Math Guides
Math FAQ
Education Articles
Education Guides
Bio/Chem Articles
Technology Guides
Computer Science Tutorials
Forums
General Math
Calculus
Differential Equations
Topology and Analysis
Linear and Abstract Algebra
Differential Geometry
Set Theory, Logic, Probability, Statistics
MATLAB, Maple, Mathematica, LaTeX
Trending
Featured Threads
Log in
Register
What's new
Search
Search
Search titles only
By:
General Math
Calculus
Differential Equations
Topology and Analysis
Linear and Abstract Algebra
Differential Geometry
Set Theory, Logic, Probability, Statistics
MATLAB, Maple, Mathematica, LaTeX
Menu
Log in
Register
Navigation
More options
Contact us
Close Menu
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Forums
Mathematics
General Math
Formula to extend a line in 3d (opposite of midpoint formula)
Reply to thread
Message
[QUOTE="LMHmedchem, post: 6762750, member: 713046"] Thanks, that worked easily. In excel, this looks like, for the new x coordinate (x3) [CODE]=A2+(A4-A2)*$D$2[/CODE] where, A2 is the cell containing x1 A4 is the cell containing x2 $D$2 is cell containing the multiplier If the multiplier is < 1.0, the new point will fall between point 1 and point 2. A multiplier value of 0.5 would give you the same result as using the midpoint formula. The multiplier must be > 1.0 for point 3 to be beyond point 2. I would guess that if the multiplier is negative, point 3 would occur on the line from point 1 to point 2 but before point 1 but I haven't confirmed that. I have a similar question but I will put that in a new thread because it is likely a more complex solution. Thanks again, [B][COLOR="#000080"]LMHmedchem[/COLOR][/B] [/QUOTE]
Insert quotes…
Post reply
Forums
Mathematics
General Math
Formula to extend a line in 3d (opposite of midpoint formula)
Back
Top