Thread
:
rounding
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
egarcia
external usenet poster
Posts: 13
rounding
I'm trying to round resources down if they are less than .5, up if greater
than a .5, and also equal to 1 if less than .5. For example 1.2 = 1, & 1.6 =
2, .4 = 1. My formula is = round(AB23/AB36,0), but less than .5 = 0
Reply With Quote
egarcia
View Public Profile
Find all posts by egarcia