An even better way to calculate nice numbers

Every afternoon when my husband comes home for lunch (we live 6 blocks from his lab) I rub his head, and he reads my blog entries.

Yesterday he pointed out that a better way to get the closest nice number that is a multiple of 8 would be to use a formula more like this- =Int(number/8+.5)*8

The +.5 part makes sure that if you are closer to the higher multiple, you get there. Otherwise your numbers are too low most of the time.

So, here is a better way to get to a nice number.

Leave a Reply

Your email address will not be published. Required fields are marked *