Rounding numbers

[Guest]

Hey,

I am a student and I am trying to figure out how I can round some grades
properly.
My question is: how do I make a formula that rounds numbers to whole
numbers, and if the decimal is .5 or higher, then round up to whole number,
if the decimal is lower than .5 round down to whole number. For example:

5.5 would become 6
5.4 would become 5

Thanks!

 

[Guest]

Hi Nico,

use =round(a2,0)

note the "0", is how many decimals you want

hope this helps
Regards from Brazil
Marcelo


"nicojr" escreveu:

 

[Guest]

You can use the ROUND function.

=ROUND(A1,0)

This assumes your value is stored in cell A1 and rounds to 0 decimal places.

HTH,
Elkar

 

[Guest]

Thanks guys, I really appreciate your quick help!

Greetings from a cold country, the Netherlands,
Nico

 

[Guest]

Hi Nico, thanks for the feedback


"nicojr" escreveu: