Round up numbers to either a half or a whole depending on which side of 0.5 it is
Hi
Thanks for the help. This is the one that I used and it seems to do just
what I want.
John
"Arvi Laanemets" wrote in message
...
Hi
"John Williams" wrote in message
...
Hi
Thanks for the two replies both of you. They both work, but if the sum
does equal say 15.5 then they both round that up to 16 and not leave it
at 15.5
=ROUNDUP((A1-0.1)/5,1)*5
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
|