ROUNDUP to nearest 1/16 (in decimals)

[jlute]

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!

 

[Bernd P]

=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

 

[jlute]

=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?

 

[Glenn]

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

 

[jlute]

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!

 

[David Biddulph]

=CEILING((V5*D5)-AB12+AC12,1/16)