Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=IF(A1=MAX($A$1:$A$3),A1,"") Adapt to use multiple "if" formula's tssgraham Excel Discussion (Misc queries) 7 June 8th 07 10:30 PM
Multiple format single cell that has formula's Brad Excel Discussion (Misc queries) 8 May 29th 07 10:27 PM
PLease help me with formula's Beth Excel Worksheet Functions 3 March 10th 06 08:42 PM
Multiple True's in IF Formula's Brad Larsen Excel Worksheet Functions 3 February 24th 06 01:22 AM
Multiple True's in IF Formula's Brad Larsen Excel Discussion (Misc queries) 4 February 23rd 06 08:59 PM


All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"