|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2009, 02:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUNDUP to nearest 1/16 (in decimals)
How can I ROUNDUP a number to the nearest 1/16? I currently have a
column with 1/16 increments listed in decimals: 1/16 = 0.0625 1/8 = 0.125 3/16 = 0.1875 etc. Do I simply do a lookup on that column? If so, how can I do this? THANKS! 
|
|
#2
May 12th, 2009, 02:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROUNDUP to nearest 1/16 (in decimals)
=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
|
|
#3
May 12th, 2009, 02:45 PM
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?
|
|
#4
May 12th, 2009, 02:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ROUNDUP to nearest 1/16 (in decimals)
|
|
#5
May 12th, 2009, 03:04 PM
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!
|
|
#6
May 12th, 2009, 04:55 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
