I am trying to find a way to round from 1.1-1.9 and have it as 2
The reason I need to do this is that I am printing out sheets of paper that have store ids for some reps. I can only fit 6 on a page I have it set so if its 6 on a page I am good if I go to 7 it goes to 1.2 and 8 is 1.3 and so on. Therefore, when I get to 11 I am at 1.8 and 12 will put me at 2 pages I will use.
What I need to do is take the ones with decimals and round them up so I will see 2 pages when it’s 1.1 or higher.
Thank you,
Charles
Bookmarks