roundup by 16s
See Help for MROUND() which is part of the Analysis ToolPak.
Jerry
"Sum Limit and marking" wrote:
I'm looking for a formula that will allow me to type in a number and roundup
to the largest multiple of 16 with a minimum of 64.
For example, if I type in 60 in Cell A1, then in cell A2 I want it to
roundup to 64.
Thanks.
|