+ Reply to Thread
Results 1 to 6 of 6

Formula issue imputing Trig

  1. #1
    Registered User
    Join Date
    12-04-2021
    Location
    alabama
    MS-Off Ver
    365
    Posts
    3

    Formula issue imputing Trig

    hello everyone. Needing help with correct formula for calculating the opposite side of an Isosceles Triangle. Given that Cell A1 is the Angle between the congruent sides. and B1 is the length of each Congruent Side. C1 is the result(length) of opposite side. My formula result in C1 keeps coming up to 0. but checking with calculator and online triangle calculator it, I should be getting a number.
    Values
    A1=15
    B1=30
    expected result in C1=7.83157


    C1(formula)=SQRT((((B1*B1)+(B1*B1))-(2*(B1*B1)))*(COS(A1)))

    *This formula is based off online Triangle Calculator formula. I dont know how to Square a #on excel, so i just multiplied a cell by itself. Im pretty sure this isnt a trig problem its more of a "im not putting it into excel properly" any help would be great.
    Thanks in advance

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Formula issue imputing Trig

    What's the trig formula? I last did matchs/trig..... decades ago!!
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Formula issue imputing Trig

    exponent for a cell
    =b1^2 =squared
    =b1^3 =cubed

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Formula issue imputing Trig

    This

    =SQRT(B1^2+B1^2-(2*B1^2*COS(RADIANS(A1))))

    or

    =SQRT(2*(B1^2)-(2*B1^2*COS(RADIANS(A1))))

    Value in A1 is in RADIANS

    or

    =SQRT(2*($B$1^2)*(1-COS(RADIANS($A$1))))
    Last edited by JohnTopley; 12-04-2021 at 10:24 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    12-04-2021
    Location
    alabama
    MS-Off Ver
    365
    Posts
    3

    Re: Formula issue imputing Trig

    [QUOTE=JohnTopley;5603009]This

    =SQRT(B1^2+B1^2-(2*B1^2*COS(RADIANS(A1))))

    ^^ that was it!!!! Thanks for the info. i'm now a little smarter.

  6. #6
    Registered User
    Join Date
    12-04-2021
    Location
    alabama
    MS-Off Ver
    365
    Posts
    3

    Re: Formula issue imputing Trig

    thank you for the info on exponets. that helped

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I need help matching 2 separate ID's and imputing the corresponding data in a column.
    By Adamngoptions in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2018, 12:04 PM
  2. Trig formula problem
    By prostreet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-09-2016, 10:06 AM
  3. [SOLVED] trig functions
    By James__S in forum Excel General
    Replies: 2
    Last Post: 03-23-2015, 03:16 AM
  4. Using LINEST for trig functions
    By MichaelP in forum Excel General
    Replies: 5
    Last Post: 05-30-2012, 10:25 AM
  5. Replies: 2
    Last Post: 04-07-2011, 06:37 AM
  6. UDF using Trig
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2011, 03:21 PM
  7. Trig formula unexpected results.
    By troth in forum Excel General
    Replies: 6
    Last Post: 07-23-2010, 09:33 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1