roundup by 16s
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. |
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. |
roundup by 16s
Try this:
For a value in A1 B1: =MAX(CEILING(A1,16),64) Does that help? *********** Regards, Ron XL2002, WinXP "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. |
roundup by 16s
In A2,
=MAX(64,IF(MROUND(A1,16)<A1,MROUND(A1+16,16),MROUN D(A1,16))) HTH, Bernie MS Excel MVP "Sum Limit and marking" wrote in message ... 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. |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com