HELP with Rounding

[Guest]

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.

 

[Guest]

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.

 

[Guest]

Try using the ROUNDUP() function instead.

=ROUNDUP(A1,0)

HTH,
Elkar

 

[Bob Phillips]

=CEILING(A2,1)

--

HTH

Bob Phillips

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

 

[PCLIVE]

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

=roundup(A1,0)

HTH,
Paul

 

[Guest]

Super - worked wonderfully. Thanks soooo much!

 

[Guest]

Hi Sandi,

you dont need to "back up" negative numbers, isn't it?

happy holidays