Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
how to loose all numbers after decimal (not rounding) | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |