ROUNDUP to nearest 1/16 (in decimals)

  • Thread starter Thread starter jlute
  • Start date Start date
J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight date nearest to TODAY() 4
help to in setting up a proper Vlookup table and formula 4
Count Unique With one Condition & No ROUNDUP 7
ROUNDUP and -1 6
Using Roundup in an IF Statement 2
can't roundup sum 3
Convert inches & display as Feet Inches and Fractions -- BUG FREE 9
INDEX MATCH SMALL 12

Back
Top