+ Reply to Thread
Results 1 to 5 of 5

Round up of values to the next multiple of 50 cents

  1. #1
    Registered User
    Join Date
    12-13-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel Workbook
    Posts
    8

    Round up of values to the next multiple of 50 cents

    I need to be able to round up the values to the next multiple of 50 cents, eg 336 to $3.50. Thi is used in calculating the minimum value of bets in doubles, trebles, quadrellas and trifectas in Australian horse race betting. If the combinations of selections comes to say 336, I need to calculate the round up value to $3.50. Similarly 489 combinations would be rounded up to $5. I have attached a simple spreadsheet which details what is wish to achieve. At least I downloaded it but then closed the window as I have no option other than that to get out of the program. I assume it downloads but if not, the issue is adequately explained above.

    Trusting someone may be able to help.

    Thanking you.

    Peter Campbell
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Round up of values to the next multiple of 50 cents

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Round up of values to the next multiple of 50 cents

    Try this

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B
    1 336 $3.50
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Round up of values to the next multiple of 50 cents

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    will convert 3.36 to 3.50

    OR

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  5. #5
    Registered User
    Join Date
    12-13-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel Workbook
    Posts
    8

    Re: Round up of values to the next multiple of 50 cents

    Thank you so much davesexcel, saravnepali & ALKEY for your prompt and accurate information. I had tried all sorts of means to get the result but the "team" did it no time whatsoever. Thank you all very much and all the best.

    Peter Campbell
    Australia

+ 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. ROUND CENTS TO EITHER 49 OR 99 AMOUNTS
    By PRICEMGR in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-30-2021, 09:56 AM
  2. [SOLVED] Round to nearest 0.50 cents
    By Fredbugatti in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-23-2018, 01:54 PM
  3. Round up values
    By structo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2017, 01:41 PM
  4. [SOLVED] looking to round values up
    By greggatz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-16-2015, 03:34 PM
  5. How to round values up
    By Vbort44 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2008, 12:56 AM
  6. Problem getting cents to round, Merged document
    By LTUser54 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2008, 11:32 AM
  7. I am trying to round up to the nearest 25 cents
    By sypher in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-25-2005, 09:06 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