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!