ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiple formula's in one row (https://www.excelbanter.com/excel-worksheet-functions/222988-multiple-formulas-one-row.html)

machinist 101

multiple formula's in one row
 
i'm trying to setup a formula that will figure out some trig for me. angle,
legnth of opposite side, legnth of hypotinuse, and length of adjacent side.
i want to beable to just set up 4 block and put the known numbers in it and
have it put the missing numbers in it. i have all the formulas to get the
results, but i just want to simplify it down to one row.

Shane Devenshire

multiple formula's in one row
 
Hi,

So what is your question?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"machinist 101" wrote:

i'm trying to setup a formula that will figure out some trig for me. angle,
legnth of opposite side, legnth of hypotinuse, and length of adjacent side.
i want to beable to just set up 4 block and put the known numbers in it and
have it put the missing numbers in it. i have all the formulas to get the
results, but i just want to simplify it down to one row.


machinist 101[_2_]

multiple formula's in one row
 
what do i need to do to get it simplified right now its
trig angle length opp length hyp length adj
find angle 25.0 0.0625 0.148
25.1 0.148 0.134
25.0 0.0625 0.134

length of opp side 25.0 0.063 0.148
25.0 0.062 0.134

LEGNTH OF ADJ 25.0 0.0625 0.134
25.0 0.148 0.134

legnth for hyp side 25.0 0.0625 0.148
25.0 0.148 0.134

i just want it simply one row to figure out the equations and fill in the
missing information like
find angle angle leg opp leg hyp leg adj
25 0.0625 0.148 0.134
how do i do it????????
please explain it very simply because i'm new to using excel
thankx


"Shane Devenshire" wrote:

Hi,

So what is your question?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"machinist 101" wrote:

i'm trying to setup a formula that will figure out some trig for me. angle,
legnth of opposite side, legnth of hypotinuse, and length of adjacent side.
i want to beable to just set up 4 block and put the known numbers in it and
have it put the missing numbers in it. i have all the formulas to get the
results, but i just want to simplify it down to one row.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com