SOLVED

rounding results to a larger whole number in excel

Copper Contributor

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
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
best response confirmed by sunco (Copper Contributor)
Solution
Use this formula:
=CEILING(A1,1)

@Twifoo 

Dear Sir,

Thank you for your response and help

with respect

You're very much welcome!
1 best response

Accepted Solutions
best response confirmed by sunco (Copper Contributor)
Solution
Use this formula:
=CEILING(A1,1)

View solution in original post