HELP with Rounding

S

Sandi

I have a spreadsheet with numbers that appear as so:

2.1
2.5
3.2
2.1

I used the ROUND function to round the numbers but for the 2.1 it takes it
down to 2. I need it to bring it back up to 3. Is that possible. Any help
will be appreciated.
 
L

~L

Instead of Round, use Roundup. For example if those numbers are in column a,
the formula would be =ROUNDUP(A2,0) The 0 being for how many digits after the
decimal you want. This means 2.1 will round to 3.
 
B

Bob Phillips

=CEILING(A2,1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
P

PCLIVE

If you want everything to be rouded up to the nearest integer, then:

=roundup(A1,0)

HTH,
Paul
 
Top