Forum Discussion

sunco's avatar
sunco
Copper Contributor
Mar 14, 2019
Solved

rounding results to a larger whole number in excel

Respected Ladies and Gentlemen
I ask for help and instructions.
I need to get excel in the number that is rounded up to a larger whole number of results (for example: the result is 2.01, 2.01, 20.3 ... and I want to be rounded to 3)

With respect
Sulejman Babic
sulejmanba@gmail.com

4 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Use this formula:
    =CEILING(A1,1)
  • sunco's avatar
    sunco
    Copper Contributor
    Thank you for this quick reply

    I sent it a couple of minutes ago.

    Not so urgent, so I can wait a day or two

    Thank you very much

Resources