Henry Olive 5 Posted October 8, 2023 Good Day I want to round numbers 1 level UP, How can i do it ? If Value = 0,1 then Result= 1 If Value = 1,01 then Result= 2 If Value = 2,2 then Result= 3 If Value = 3,9 then Result= 4 If Value = 4,26 then Result= 5 etc Thank You Share this post Link to post
Uwe Raabe 2064 Posted October 8, 2023 The corresponding function is Ceil. 1 Share this post Link to post
limelect 48 Posted October 10, 2023 First, change the comma to point then use the cell function Share this post Link to post