+ Reply to Thread
Results 1 to 4 of 4

Having Trouble dividing multiple arguments in the same cell

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    11

    Having Trouble dividing multiple arguments in the same cell

    V = 100 x [E /(IY + YP)] x Sqr. [((R + G)/2 / (IY + YP + F)]
    V = 100 x [6.10 /(5.60)] x Sqr. [((10.2+2)/2 / (5.60 + 2.1]
    V = 108.93 x Sqr (.79)
    V = $96.89 / share as of 7/18/2014



    E = Earnings in $ / share 6.1 (b9)
    IY = Interest rate in % 5.6 (b10)
    R = Profitability Factor in % (internal growth rate) 10.2 (b11)
    G = Earnings Growth in % / yr. 2 (b12)
    F = Inflation Rate in % / yr. 2.1 (b13)

    Here's what I have, result should be $96.89, I need to tell excel to take square root of everything to the right not just (B11+ B12)

    =100*(+B9/B10)*SQRT(B11+B12)/2/(B10+B13)

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Having Trouble dividing multiple arguments in the same cell

    Sqrt((b11+b12)/2/(b10+b13))
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-26-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    11

    Thumbs up Re: Having Trouble dividing multiple arguments in the same cell

    Great works perfectly. I was playing with the parenthesis but you nailed it.

    Is there something out there to teach users how to use parenthesis correctly?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Having Trouble dividing multiple arguments in the same cell

    No, they just follow the rules of algebra.

+ 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] Multiple IF arguments in the one cell
    By rooboyz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2013, 08:53 PM
  2. Replies: 3
    Last Post: 08-29-2011, 12:42 AM
  3. Vlookup of 1 cell containing multiple search arguments
    By MSazza in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-22-2011, 09:40 AM
  4. Multiple IF arguments in single cell
    By rideahonda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2010, 05:30 PM
  5. If then multiple arguments for single cell
    By MSTARS in forum Excel General
    Replies: 8
    Last Post: 11-15-2008, 06:31 PM

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