Rounding numbers
 

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!

Rounding numbers
 

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!

Rounding numbers
 

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!

Rounding numbers
 

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!

Rounding numbers
 

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!