Round up (multiples of 12)

Rodrigum4
✭✭
Hello
I would like to place any number in a cell, and in another cell to put a formula that will help me round the number placed in multiples of 12
that is, if I put any number from 1 to 12, my result is 12
for example if I put 22, I round to 24 (since it is the next multiplo of 12)
Comments
-
I may have an extra step in here, but this formula should work for positive integers:
=(INT((Number@row - 0.5) / 12) + 1) * 12
-
Wow! you have reason!!
Thanks for all!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives