Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
mslenora
mslenora asked in Computers & InternetProgramming & Design · 1 decade ago

Rounding up to the nearest 5 cents in Excel?

How do you round up a cell to go to the next 5 cents. eg. round .04 upto 0.05 or round .12 up to .15. I tried MROUND but that takes me down and I always want to go up? I looked in ROUNDUP but it seems to only have the option to choose the number of digits.

5 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Use the CEILING function.

    example. =CEILING(A1,0.05)

    This will round up to the nearest 5 cents

  • IXL@XL
    Lv 7
    1 decade ago

    Enter the amount required to be rounded in D2.

    In E2 type following (all one line, no spaces)

    =IF(ROUND(MOD(D2*100,5),1)<3, FLOOR(D2,0.05), CEILING(D2,0.05))

    Use it all the time at work. Rounds down if value 1 or 2 or 6 or 7, rounds up if values 3 or 4 or 8 or 9.

  • ?
    Lv 4
    5 years ago

    How To Roundup In Excel

    Source(s): https://shrink.im/a81cC
  • brisco
    5 years ago

    I agree with you Nelson M, this is the simplest way of rounding "MROUND(G24,0.05)

  • How do you think about the answers? You can sign in to vote the answer.
  • Nelson M
    6 years ago

    try =mround(A1, 0.05)

Still have questions? Get your answers by asking now.