Excel Ceiling Roundup Functions

Excel Question: What IF Function to use Cell A1 1 to 10 Value 1, 11-20 value 2, 21-30 value 3, ...?

31 to 40 value 4, 41 to 50 value 5.
example A1 = 05 then B1 = 1
A1 = 11 then B1 = 2
A1 = 30 then B1 = 3
A1 = 38 then B1 = 4
A1 = 46 then B1 = 5

by C Masters

Best Answer - Chosen by Asker

it would be easier to make this a mathematical function than a logical function
instead of using many IF statements to check the value, you can use a formula like this

=CEILING(A1,10)/10 or =ROUNDUP(A1/10,0)