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!

Hi Nico,

use =round(a2,0)

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

hope this helps
Regards from Brazil
Marcelo


"nicojr" escreveu:

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!

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


"nicojr" wrote:

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!

Thanks guys, I really appreciate your quick help!

Greetings from a cold country, the Netherlands,
Nico

"Elkar" wrote:

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


"nicojr" wrote:

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!

Hi Nico, thanks for the feedback


"nicojr" escreveu:

Thanks guys, I really appreciate your quick help!

Greetings from a cold country, the Netherlands,
Nico

"Elkar" wrote:

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


"nicojr" wrote:

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!