Rounding up to a specific number

[themattman007]

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

[steven-g]

See your other post https://forums.autodesk.com/t5/autocad-lt-forum/rounding-up-to-a-specific-number/m-p/9628785#M184340

[tombu]

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.