Can I change my round function to round up if 5 or above and down if below 5?
G GinGinW73 Oct 26, 2007 #1 Can I change my round function to round up if 5 or above and down if below 5?
P Pete_UK Oct 26, 2007 #2 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
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
