Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Formulas from formulas (Excel 2000)

    I have a formula that doesn't add up and I believe it is because I'm asking formula "b" to take the answer from formula "a" and then calculate the answer. I've attached an example. As you can see, cell E17 contains a formula that refers back to cell F9 which also has a formula. When we do the computation on a calculator, we get $998 but when we try to do it in Excel, we get $986. Same is for the one directly below it (should be $1331). How do I make a formula read only the answer from another formula to get a final total as in my example? Thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calculating Formulas from formulas (Excel 2000)

    Rounding error
    When you use a calculator you multiply "4340.44" * "23%" to get "998.3012"
    Excel is multiplying "4340.44" * "22.7272727272727%" to get "986.463636363635"

    If you want excel to use only 2 decimal places for F9 use in E17:
    =+D17*ROUND(F9,2)
    and in E18:
    =+D18*ROUND(F9,2)

    or keep the formulas in E17 and E18 and use in F9:
    =ROUND(F8/D8,2)

    Steve

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Formulas from formulas (Excel 2000)

    Thank you Steve! You've saved me yet again

Posting Permissions

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