Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
Can I change my round function to round up if 5 or above and down if below 5?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
That is what the ROUND function does, eg:
=ROUND(A1,0) You might also like to look at ROUNDUP, ROUNDDOWN, CEILING, FLOOR, INT, TRUNC functions in Excel Help. Hope this helps. Pete On Oct 26, 2:54 pm, GinGinW73 wrote: Can I change my round function to round up if 5 or above and down if below 5? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
=Round(A1,-1)
if I understand you correctly. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding or not rounding | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) |