Results 1 to 4 of 4

Round including formula

Threaded View

  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.

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