software

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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=520843Use 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.comquot;Neo1quot; gt; wrote
in message
...
gt;
gt; Hello, is there a way to round of a number say something like
gt; this:
gt;
gt; 13.2 to 14 instead of going to 13...how can I do this?
gt;
gt; Thanks
gt; From John
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=520843
gt;
=ROUNDUP(A12,0)

Regards

Trevorquot;Neo1quot; gt; wrote in message
...
gt;
gt; Hello, is there a way to round of a number say something like this:
gt;
gt; 13.2 to 14 instead of going to 13...how can I do this?
gt;
gt; Thanks
gt; From John
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=520843
gt;
Hi John,

=ROUNDUP(A1,0)

Gilles

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

=roundup(c10,0)--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=520843Number 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

quot;Neo1quot; gt; wrote in message
...
gt;
gt; Hello, is there a way to round of a number say something like this:
gt;
gt; 13.2 to 14 instead of going to 13...how can I do this?
gt;
gt; Thanks
gt; From John
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=520843
gt;
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,
Elkarquot;Neo1quot; wrote:

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

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

quot;Chip Pearsonquot; wrote:

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

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

Yeah, you're right. My mistake.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Elkarquot; gt; wrote in message
...
gt; Acutally, ROUNDUP is not part of the Analysis ToolPak. Perhaps
gt; you're
gt; thinking of MROUND?
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; Use the ROUNDUP function. E.g.,
gt;gt;
gt;gt; =ROUNDUP(A1,0)
gt;gt;
gt;gt; ROUNDUP is part of the Analysis Tool Pak add-in, so you must
gt;gt; have
gt;gt; this loaded to use the function. Go to the Tools menu, choose
gt;gt; Add-Ins, and put a check next to Analysis Tool Pak.
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt; quot;Neo1quot; gt;
gt;gt; wrote
gt;gt; in message
gt;gt; ...
gt;gt; gt;
gt;gt; gt; Hello, is there a way to round of a number say something
gt;gt; gt; like
gt;gt; gt; this:
gt;gt; gt;
gt;gt; gt; 13.2 to 14 instead of going to 13...how can I do this?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt; From John
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Neo1
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; Neo1's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30329
gt;gt; gt; View this thread:
gt;gt; gt; www.excelforum.com/showthread...hreadid=520843
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;

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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=520843