How do I get a value to round to (1) the nearest half (2) the nearest quarter?
So
8:23 would yield 8.25 & 8.00
72.67 would yield 72.75 & 72.50
Thanks.
How do I get a value to round to (1) the nearest half (2) the nearest quarter?
So
8:23 would yield 8.25 & 8.00
72.67 would yield 72.75 & 72.50
Thanks.
I suspect there's more than one way to do that. Here're my thoughts.
Nearest 0.25:
=INT(A4)+ROUND(MOD(A4,1)/0.25,0)*0.25
Nearest 0.50:
=INT(A4)+ROUND(MOD(A4,1)/0.5,0)*0.5
Do those work for you?
Regards,
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks