I have data with all possible integers from 0 - 100, and I'd like to convert this into 0-10 answers so that
0= 0
1-10 = 1
11- 20 = 2
21 - 30 = 3
etc.
I have data with all possible integers from 0 - 100, and I'd like to convert this into 0-10 answers so that
0= 0
1-10 = 1
11- 20 = 2
21 - 30 = 3
etc.
That looks to me like =CEILING(number,10)/10. CEILING() function help file: https://support.office.com/en-us/art...c-c943e510899f
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks