+ Reply to Thread
Results 1 to 4 of 4

Round including formula

  1. #1
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    318

    Round including formula

    Good morning all.
    Have not been here for a while. Always good though.

    I need to round up cells which already have formula in them. I have looked on our site and have not found the answer though it may be there.
    I have used ' =ROUND(E25+E26,0) to round up a simple calculation and as directed on this forum inserted my formula inside. Works great.
    I am trying to use the same principle =ROUND(E24/(SUM(E17*$B$29))-D25),0) here without luck.
    I attach a spread sheet if it’s any help. On the sheet are two identical sets of calculations with one showing the number expanded to show the decimal points.
    Hope this helps. In London here and the sun is shining, it’s a glorious day.

    All the Best Mark
    For My Excel.xlsx
    Last edited by markDuffy; 06-18-2013 at 01:50 PM.

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Round including formula

    Hi,
    Are you sure about this part of the formula?
    E24/(SUM(E17*$B$29))-D25

    I am not able to understand why that sum is required there...

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Round including formula

    How about..

    =ROUND(E24/(E17*$B$29-D25),0)

    In Dubai here and the sun is balzing down, it’s been a usual hot day!
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Thumbs up Re: Round including formula

    Working fine for me now..

    check the attachment

    Excel.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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