+ Reply to Thread
Results 1 to 4 of 4

The sum of numbers, Rounded to the next .05

  1. #1
    Registered User
    Join Date
    12-12-2011
    Location
    Eatontown, NJ
    MS-Off Ver
    Excel 2011 mac
    Posts
    3

    The sum of numbers, Rounded to the next .05

    I may not be asking this correctly, But let me try to explain what I need help with.

    I am creating a spreadsheet for being able to quote a price to customers. I am looking for a formula to automatically round the sum of several numbers to the next .05 increment.

    For example: My product costs $10.35, my freight costs $4.71 my commission is .35 cents my total cost is $15.41 cents.

    I would like to take the sum of those 3 numbers, and round it to the next .05 increment. in this case $15.45

    I have a separate sheet, that I have linked the results of the equation, that I am using for my quote sheet, and do not want to have to go change the answers manually, but to have it automatically completed.


    I am currently using the formula below, bit will only round up to the next .10 interval. And if I change the 1 to a 2, it does not round up, it gives me exact price.

    =ROUNDUP(SUM(B3+D3+E3),1)

    So in other words.. HELLLPPPPPPPPPPPP

    Sincerely,
    Somebody who does not know what the are doing.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,730

    Re: The sum of numbers, Rounded to the next .05

    Try CEILING, i.e.

    =CEILING(SUM(B3,D3,E3),0.05)
    Audere est facere

  3. #3
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: The sum of numbers, Rounded to the next .05

    mattio,

    Welcome to the forum!
    Give this a try:
    =CEILING(SUM(B3,D3:E3),0.05)

    EDIT: Got beat to it by DLL
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    12-12-2011
    Location
    Eatontown, NJ
    MS-Off Ver
    Excel 2011 mac
    Posts
    3

    Thumbs up Re: The sum of numbers, Rounded to the next .05

    That seems to be doing the trick.

    You have no idea how happy I am !!!!!!!!

    Thanks from a total Newbie..

+ 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