themattman007 Posted July 10, 2020 Share Posted July 10, 2020 Hello all you DIESEL experts. I am trying to create a spreadsheet type formula to round up numbers to a specific number. Below is the working formula in excel. I need to get this formula to work in AutoCAD 2014 Lt. =IF(B3=2,2,IF(B3=3,3,IF(B3=4,4,IF(B3=5,6,IF(B3=6,6,IF(B3=7,7,IF(B3=8,8,IF(B3=9,10,IF(B3=10,10,IF(B3=11,13,IF(B3=12,13,IF(B3=13,13,IF(B3=14,15,IF(B3=15,15,IF(B3=16,20,IF(B3=17,20,IF(B3=18,20,IF(B3=19,20,IF(B3=20,20,IF(B3=21,25,IF(B3=22,25,IF(B3=23,25,IF(B3=24,25,IF(B3=25,25,IF(B3=26,30,IF(B3=27,30,IF(B3=28,30,IF(B3=29,30,IF(B3=30,30))))))))))))))))))))))))))))) Thank you for any advice. Matt Quote Link to comment Share on other sites More sharing options...
steven-g Posted July 10, 2020 Share Posted July 10, 2020 See your other post https://forums.autodesk.com/t5/autocad-lt-forum/rounding-up-to-a-specific-number/m-p/9628785#M184340 1 Quote Link to comment Share on other sites More sharing options...
tombu Posted July 11, 2020 Share Posted July 11, 2020 Helpful link: https://www.fourmilab.ch/diesel/ As a LT user you should learn to use DIESEL, I've only used the full version and would use lisp for something like this. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.