Hi Guys
probably an easy one here
I need to round cell values up of over .5 or down if under and if .5 round up so say 3.67 to 4 and 3.64 to 3 etc
Im sure its easy.
Hi Guys
probably an easy one here
I need to round cell values up of over .5 or down if under and if .5 round up so say 3.67 to 4 and 3.64 to 3 etc
Im sure its easy.
=round(a1,0)
round down is from 0 and roundup is towards 0
3.67 =+ROUNDUP(A1,0) increases value towards next whole digit or near whole digit
3.67 =+ROUNDDOWN(A2,0) decreases value towards next whole digit or near whole digit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks