How to round off the decimal to the nearest number

[keychain]

Hi, my query is simple..

If a cell has a value 100.82

It should show as 101.00 or 100.

Kindly help out with a formula

 

[Peter_SSs]

If the value is in A1, is this what you mean?

=ROUND(A1,0)

 

[keychain]

Thanks, it works.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.

BTW, I suggest that you update your forum profile (click your user name at the top right of the forum, then ‘Account details’) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)