Re: Can I use excel to find y = f(x,z)?
- From: agarwaldvk <agarwaldvk.1sfvud_1121814491.083@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Jul 2005 17:53:37 -0500
Anne
Your query could refer to two things :-
If you are referring to the distance between two points given their 3D
coordinates then yes you can do it like so :-
y (distance) = ((x1 - x2)^2 + (y1 - y2)^2 + (z1 - z2)^2)^0.5
If this is not what you are wanting to do and it is something close to
what Derek suggested then again you should be able to get the solution
for 'y' given the relationship between x and z - which you have not
explained. You may want to do that if you want better explanation on
this count.
Best regards
Deepak Agarwal
--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11345
View this thread: http://www.excelforum.com/showthread.php?threadid=388538
.
- References:
- Can I use excel to find y = f(x,z)?
- From: Ane
- Re: Can I use excel to find y = f(x,z)?
- From: Derek Y via OfficeKB.com
- Can I use excel to find y = f(x,z)?
- Prev by Date: RE: If Then, not using values, or not counting blanks
- Next by Date: refresh auto filter
- Previous by thread: Re: Can I use excel to find y = f(x,z)?
- Next by thread: Re: Can I use excel to find y = f(x,z)?
- Index(es):
Relevant Pages
|
