+ Reply to Thread
Results 1 to 9 of 9

Rounding to nearest 50 cents

  1. #1
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Rounding to nearest 50 cents

    I need a forumula that will round all numbers down to fifty cents for example:

    $10.93 would be 11$
    $10.63 would be 10.50
    $10.20 would be 10$

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Rounding to nearest 50 cents

    Your first example rounds up?

  3. #3
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Re: Rounding to nearest 50 cents

    Sorry first example would round to 10.50

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Rounding to nearest 50 cents

    Going by your example;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And copy down.

  5. #5
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Rounding to nearest 50 cents

    Quote Originally Posted by Fredbugatti View Post
    Sorry first example would round to 10.50
    Then;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And copy down.

  6. #6
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Re: Rounding to nearest 50 cents

    What is the second formula for?

  7. #7
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Rounding to nearest 50 cents

    Try

    =ROUND(A1*2,0)/2

  8. #8
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Rounding to nearest 50 cents

    I modified it to give $10.50 for case 1.

  9. #9
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Re: Rounding to nearest 50 cents

    Great, Thanks so much!!

+ 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. rounding to nearest 5 or 10 cents
    By only_lonely in forum Excel General
    Replies: 6
    Last Post: 07-16-2018, 02:14 AM
  2. [SOLVED] stop rounding to the nearest cents
    By dusty88881 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-19-2013, 04:15 PM
  3. Rounding to nearest .05 or .09 cents.
    By Kakita in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-04-2013, 07:39 PM
  4. Rounding currency to the nearest .x9 cents
    By mashley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2008, 06:16 PM
  5. Rounding to the nearest 50 cents?
    By hallenbeck in forum Excel General
    Replies: 3
    Last Post: 01-04-2007, 02:13 PM
  6. Currency Rounding to nearest 5 cents
    By Daniel Sloan in forum Excel General
    Replies: 3
    Last Post: 07-20-2006, 03:50 AM
  7. Rounding to nearest 5 cents in excel
    By usnst in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2006, 08:35 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