| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUNDUP to nearest 1/16 (in decimals)
On May 12, 9:34*am, Bernd P wrote:
=ROUNDUP(A2*16,0)/16 will round UP to next 1/16. Take ROUND if you want to round to closest 1/16. Regards, Bernd Thanks, Bernd. I should've been more specific. I need to round the result of the following function to the nearest 1/16: =(V5*D5)-AB12+AC12 How can I modify this to round accordingly? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROUNDUP to nearest 1/16 (in decimals)
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROUNDUP to nearest 1/16 (in decimals)
On May 12, 9:55*am, Glenn wrote:
wrote: On May 12, 9:34 am, Bernd P wrote: =ROUNDUP(A2*16,0)/16 will round UP to next 1/16. Take ROUND if you want to round to closest 1/16. Regards, Bernd Thanks, Bernd. I should've been more specific. I need to round the result of the following function to the nearest 1/16: =(V5*D5)-AB12+AC12 How can I modify this to round accordingly? Substitute your function for A2 in Bernd's function. =ROUNDUP(((V5*D5)-AB12+AC12)*16,0)/16 Good grief! Thanks, Glenn! I was going about this the hard way! Thanks, Bernd! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROUNDUP to nearest 1/16 (in decimals)
=CEILING((V5*D5)-AB12+AC12,1/16)
-- David Biddulph wrote in message ... On May 12, 9:34 am, Bernd P wrote: =ROUNDUP(A2*16,0)/16 will round UP to next 1/16. Take ROUND if you want to round to closest 1/16. Regards, Bernd Thanks, Bernd. I should've been more specific. I need to round the result of the following function to the nearest 1/16: =(V5*D5)-AB12+AC12 How can I modify this to round accordingly? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Roundup to nearest $.0.05 Help | Excel Discussion (Misc queries) | |||
| HOW DO I ROUNDUP A RESULT OF A FORMULA TO NEAREST WHOLE NUMBER | Excel Worksheet Functions | |||
| formula to roundup to the nearest 9 | Excel Worksheet Functions | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
| How do I roundup to the nearest 9 | New Users to Excel | |||
Hybrid Mode
