Find length of side of triangle in Excel

Excel Discussion in 'Microsoft Office' started by JSK, Sep 13, 2017.

  1. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    Hi i am Jo

    would need help in finding the length of the third side of a triangle in excel

    I have three points number: AB- 235 BC- 156 need to find length AC - it's not a right angle triangle,
     
    JSK, Sep 13, 2017
    #1
    1. Advertisements

  2. JSK

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    700
    Welcome to the forums Jo.

    Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.
     
    Ian, Sep 13, 2017
    #2
    1. Advertisements

  3. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    Thanks Iain for getting back/
    Iain and i am trying to format it in Excel, isn't it possible based on the chart where it has an X and Y axis too
     
    JSK, Sep 14, 2017
    #3
  4. JSK

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    700
    I don't understand what you mean unfortunately - can you please take a screenshot of the problem, as that may help me see what you're trying to achieve :).
     
    Ian, Sep 14, 2017
    #4
  5. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    I have drawn lines in excel, any options in excel where it can evaluate the axis and evaluate the length of the third side.
    Eg: if i draw the same line in the piece of paper it's easy. anything possible in excel.
     

    Attached Files:

    JSK, Sep 14, 2017
    #5
  6. JSK

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    700
    What's the X axis measurements? It just says 1,2 and 3 - which I guess isn't a real value (or is it)? Your "triangle" has lines that cross almost 200 units on the Y axis, but only 1 or 2 units on the X axis.

    Is this data coming from cells somewhere?
     
    Ian, Sep 14, 2017
    #6
  7. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    3 POINTS.PNG
     
    JSK, Sep 14, 2017
    #7
  8. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    i have got the data in excel and have drawn a line chart, and need to find the line "AC"
     
    JSK, Sep 14, 2017
    #8
  9. JSK

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    700
    I don't know what A, B and C are - it's just numbers. AB is the difference between A and B, but isn't the line length on that graph you've drawn, it's just the difference in height. Same for CB.

    If you can explain where you've got this from, I may be able to help.
     
    Ian, Sep 14, 2017
    #9
  10. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    Ian
    EG: DJI daily data the analysis formulates the base high /low and buy /sell prices
    setting targets and stop loss. the base high low is flowing in a triangular format, to analyse it better I am after the third line. attached is the pic . its very good I believe
     

    Attached Files:

    • DJI.PNG
      DJI.PNG
      File size:
      838.2 KB
      Views:
      7
    JSK, Sep 14, 2017
    #10
  11. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    the previous one has not been formalised? this is the correct one
     

    Attached Files:

    • DJI.PNG
      DJI.PNG
      File size:
      750.5 KB
      Views:
      7
    JSK, Sep 14, 2017
    #11
  12. JSK

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    700
    Sorry @JSK, I'm not sure how to do what you're asking as don't see how it's possible to calculate the numerical length with that information - it may be worth asking some traders, as it sounds fairly specific to that. Sorry I can't be of more help.
     
    Ian, Sep 14, 2017
    #12
  13. JSK

    JSK

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    Location:
    Perth
    Thank Ian for your time and reference. I was thinking more from the maths point of view, doesn't matter stocks or just normal length. :)
     
    JSK, Sep 14, 2017
    #13
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. renkumari
    Replies:
    0
    Views:
    3,025
    renkumari
    May 30, 2009
  2. GodBlessJoanie

    Excel Can't open an Excel file unless Excel is open

    GodBlessJoanie, Aug 25, 2010, in forum: Microsoft Office
    Replies:
    3
    Views:
    976
    smithb2
    Aug 31, 2010
  3. onequinn
    Replies:
    0
    Views:
    1,127
    onequinn
    Sep 27, 2011
  4. rtejera

    Access Pulling a variable length string in MS Access

    rtejera, Oct 5, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    596
    rtejera
    Oct 5, 2011
  5. Johnnyspa
    Replies:
    2
    Views:
    1,124
    Johnnyspa
    Oct 30, 2012
  6. CristinaCrouch

    Excel Any excel Wizards? Please help, can't find answer in any threads

    CristinaCrouch, Aug 24, 2013, in forum: Microsoft Office
    Replies:
    2
    Views:
    1,189
    will.b
    Sep 24, 2013
  7. khurshedp

    Excel VBA excel - find and delete

    khurshedp, Aug 1, 2014, in forum: Microsoft Office
    Replies:
    2
    Views:
    823
    Monika
    Feb 21, 2015
  8. tamesh

    Excel excel text find

    tamesh, Feb 18, 2015, in forum: Microsoft Office
    Replies:
    0
    Views:
    398
    tamesh
    Feb 18, 2015
Loading...