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.
--
Sandi Gardner

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.

"Sandi" wrote:

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.
--
Sandi Gardner

Try using the ROUNDUP() function instead.

=ROUNDUP(A1,0)

HTH,
Elkar


"Sandi" wrote:

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.
--
Sandi Gardner

=CEILING(A2,1)

--

HTH

Bob Phillips

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

"Sandi" wrote in message
...
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.
--
Sandi Gardner

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

=roundup(A1,0)

HTH,
Paul

"Sandi" wrote in message
...
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.
--
Sandi Gardner

Super - worked wonderfully. Thanks soooo much!
--
Sandi Gardner


"Bob Phillips" wrote:

=CEILING(A2,1)

--

HTH

Bob Phillips

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

"Sandi" wrote in message
...
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.
--
Sandi Gardner

I think this is what you're after:

=ROUNDUP(A1,0)

Regards,
Jon


--
Jon von der Heyden
------------------------------------------------------------------------
Jon von der Heyden's Profile: http://www.officehelp.in/member.php?userid=4852
View this thread: http://www.officehelp.in/showthread.php?t=1273736

Posted from - http://www.officehelp.in

Hi Sandi,

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

happy holidays


"Sandi" wrote:

Super - worked wonderfully. Thanks soooo much!
--
Sandi Gardner


"Bob Phillips" wrote:

=CEILING(A2,1)

--

HTH

Bob Phillips

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

"Sandi" wrote in message
...
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.
--
Sandi Gardner