Rounding Off!?

**Neo1** · 03-09-2006, 07:37 PM

Hello, is there a way to round of a number say something like this:

13.2 to 14 instead of going to 13...how can I do this?

Thanks
From John

Chip Pearson · 03-09-2006, 08:00 PM

Use the ROUNDUP function. E.g.,

=ROUNDUP(A1,0)

ROUNDUP is part of the Analysis Tool Pak add-in, so you must have
this loaded to use the function. Go to the Tools menu, choose
Add-Ins, and put a check next to Analysis Tool Pak.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Neo1" <Neo1.24feso_1141948187.9794@excelforum-nospam.com> wrote
in message
news:Neo1.24feso_1141948187.9794@excelforum-nospam.com...
>
> Hello, is there a way to round of a number say something like
> this:
>
> 13.2 to 14 instead of going to 13...how can I do this?
>
> Thanks
> From John
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile:
> http://www.excelforum.com/member.php...o&userid=30329
> View this thread:
> http://www.excelforum.com/showthread...hreadid=520843
>

Gilles Desjardins · 03-09-2006, 08:00 PM

Hi John,

=ROUNDUP(A1,0)

Gilles

"Neo1" <Neo1.24feso_1141948187.9794@excelforum-nospam.com> wrote in message
news:Neo1.24feso_1141948187.9794@excelforum-nospam.com...
>
> Hello, is there a way to round of a number say something like this:
>
> 13.2 to 14 instead of going to 13...how can I do this?
>
> Thanks
> From John
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile:
> http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=520843
>

Trevor Shuttleworth · 03-09-2006, 08:00 PM

=ROUNDUP(A12,0)

Regards

Trevor

"Neo1" <Neo1.24feso_1141948187.9794@excelforum-nospam.com> wrote in message
news:Neo1.24feso_1141948187.9794@excelforum-nospam.com...
>
> Hello, is there a way to round of a number say something like this:
>
> 13.2 to 14 instead of going to 13...how can I do this?
>
> Thanks
> From John
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile:
> http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=520843
>

**davesexcel** · 03-09-2006, 08:01 PM

=roundup(c10,0)

Bernard Liengme · 03-09-2006, 08:10 PM

Number 13.2 in A1, then both of these give 14
(a) =ROUNDUP(A1,0)
(b) =CEILING(A1,1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Neo1" <Neo1.24feso_1141948187.9794@excelforum-nospam.com> wrote in message
news:Neo1.24feso_1141948187.9794@excelforum-nospam.com...
>
> Hello, is there a way to round of a number say something like this:
>
> 13.2 to 14 instead of going to 13...how can I do this?
>
> Thanks
> From John
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile:
> http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=520843
>

Elkar · 03-09-2006, 08:10 PM

You can use the ROUNDUP() function:

=ROUNDUP(A1,0)

Where A1 is your value or formula and the 0 is how many decimal places to
round to.

HTH,
Elkar

"Neo1" wrote:

>
> Hello, is there a way to round of a number say something like this:
>
> 13.2 to 14 instead of going to 13...how can I do this?
>
> Thanks
> From John
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=520843
>
>

Elkar · 03-09-2006, 08:20 PM

Acutally, ROUNDUP is not part of the Analysis ToolPak. Perhaps you're
thinking of MROUND?

"Chip Pearson" wrote:

> Use the ROUNDUP function. E.g.,
>
> =ROUNDUP(A1,0)
>
> ROUNDUP is part of the Analysis Tool Pak add-in, so you must have
> this loaded to use the function. Go to the Tools menu, choose
> Add-Ins, and put a check next to Analysis Tool Pak.
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Neo1" <Neo1.24feso_1141948187.9794@excelforum-nospam.com> wrote
> in message
> news:Neo1.24feso_1141948187.9794@excelforum-nospam.com...
> >
> > Hello, is there a way to round of a number say something like
> > this:
> >
> > 13.2 to 14 instead of going to 13...how can I do this?
> >
> > Thanks
> > From John
> >
> >
> > --
> > Neo1
> > ------------------------------------------------------------------------
> > Neo1's Profile:
> > http://www.excelforum.com/member.php...o&userid=30329
> > View this thread:
> > http://www.excelforum.com/showthread...hreadid=520843
> >
>
>
>

Chip Pearson · 03-09-2006, 08:35 PM

> Actually, ROUNDUP is not part of the Analysis ToolPak. Perhaps
> you're
> thinking of MROUND?

Yeah, you're right. My mistake.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Elkar" <Elkar@discussions.microsoft.com> wrote in message
news:AD048889-7E3A-48FB-B13C-D0B16473931D@microsoft.com...
> Acutally, ROUNDUP is not part of the Analysis ToolPak. Perhaps
> you're
> thinking of MROUND?
>
> "Chip Pearson" wrote:
>
>> Use the ROUNDUP function. E.g.,
>>
>> =ROUNDUP(A1,0)
>>
>> ROUNDUP is part of the Analysis Tool Pak add-in, so you must
>> have
>> this loaded to use the function. Go to the Tools menu, choose
>> Add-Ins, and put a check next to Analysis Tool Pak.
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>>
>> "Neo1" <Neo1.24feso_1141948187.9794@excelforum-nospam.com>
>> wrote
>> in message
>> news:Neo1.24feso_1141948187.9794@excelforum-nospam.com...
>> >
>> > Hello, is there a way to round of a number say something
>> > like
>> > this:
>> >
>> > 13.2 to 14 instead of going to 13...how can I do this?
>> >
>> > Thanks
>> > From John
>> >
>> >
>> > --
>> > Neo1
>> > ------------------------------------------------------------------------
>> > Neo1's Profile:
>> > http://www.excelforum.com/member.php...o&userid=30329
>> > View this thread:
>> > http://www.excelforum.com/showthread...hreadid=520843
>> >
>>
>>
>>

**Neo1** · 03-10-2006, 03:34 PM

The thing is i want to round up the number once it has been divided for example:

=A1/B1

I want to put that formula on C1 and the number I get there i want to round it up to the upper number which means if i get say 13.2 i want it to go to 14 not to 13 for example

From John
Thanks

Trevor Shuttleworth · 03-10-2006, 04:15 PM

OK

=ROUNDUP(A1/B1,0)

Regards

Trevor

"Neo1" <Neo1.24gy4c_1142019304.4437@excelforum-nospam.com> wrote in message
news:Neo1.24gy4c_1142019304.4437@excelforum-nospam.com...
>
> The thing is i want to round up the number once it has been divided for
> example:
>
> =A1/B1
>
> I want to put that formula on C1 and the number I get there i want to
> round it up to the upper number which means if i get say 13.2 i want it
> to go to 14 not to 13 for example
>
> From John
> Thanks
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile:
> http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=520843
>