| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Roundup to .99 endings | Excel Worksheet Functions | |||
| combine Rand & Roundup? | New Users to Excel | |||
| ROUNDUP IN 0.2 INCREMENTS | Excel Worksheet Functions | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
| How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
Linear Mode
