+ Reply to Thread
Results 1 to 14 of 14

Round up to nearest quarter

Hybrid View

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Crawley, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Round up to nearest quarter

    Now its working thanks - my error

  2. #2
    Registered User
    Join Date
    04-11-2016
    Location
    California
    MS-Off Ver
    late excel
    Posts
    1

    Question Re: Round up to nearest quarter

    great spot and thank you to whoever reads this and a giant thank you to anyone who can help.
    We need to round up to the nearest 25 in a cell. We would like to apply the formula to the cell
    instead of creating another cell with formula reading the cell with data
    We need to up quantities for printing on even sheets.
    the page has 25 tags. column 7 has all the qtys.
    not sure if it is possible without creating a new column for the result
    =ROUNDUP(A1/25,0)*25 is what i used and it worked but it is in another column to get the value
    we would like to be able to update the value with the formula in the original cell
    hope it made sense, thank you in advance.

    Glen

    949-981-6822

+ 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