how to do it without rounding off

T

ToMmY2

Excel Expert, please help :)

may I know how I can retain number like

11.82 as 11
0.63 as 0

without rounding off to 12 and 1 respectively ?

I understand that I can first round off the number and then minus one
but the problem is I have other number like 0.23, if I round off the
minus one, it will turn to -1

I got thousand of these numerical data, what can I do? :confused
 
J

Jon Quixley

Check out the ROUND function, this should give you all the option
you'll ever need

Cheers
Jo
 
Top