how do you roud up the number in Excel please?
 

I 'm preparing my paper work for my taxes. I need to know how do I round up
the number in the tax's cell. In other way how do I make the $196.79 round
up to $197and thanks a lot in advance.

maram wrote:
I 'm preparing my paper work for my taxes. I need to know how do I
round up the number in the tax's cell. In other way how do I make
the $196.79 round up to $197and thanks a lot in advance.

Have you tried typing "round" (without the quotes" into Help?

If the number is in A1, put this in B1:
=ROUNDUP(A1,0).

or

=CEILING(A1,1)

tj

"maram" wrote:

I 'm preparing my paper work for my taxes. I need to know how do I round up
the number in the tax's cell. In other way how do I make the $196.79 round
up to $197and thanks a lot in advance.

Hi

Install (when you don't have it installed jet) Analysis Toolpack Add-In, and
use ROUNDUP function.

Arvi Laanemets


"maram" wrote in message
...
I 'm preparing my paper work for my taxes. I need to know how do I round
up
the number in the tax's cell. In other way how do I make the $196.79
round
up to $197and thanks a lot in advance.

Hi Arvi
ROUNDUP is aFAIK not part of the Analysis Toolpak addin :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Arvi Laanemets wrote:
Hi

Install (when you don't have it installed jet) Analysis Toolpack
Add-In, and use ROUNDUP function.

Arvi Laanemets


"maram" wrote in message
...
I 'm preparing my paper work for my taxes. I need to know how do I
round up the number in the tax's cell. In other way how do I make
the $196.79 round up to $197and thanks a lot in advance.

Arvi was probably thinking of the MROUND function.

Gord

On Sat, 18 Dec 2004 20:12:04 +0100, "Frank Kabel"
wrote:

Hi Arvi
ROUNDUP is aFAIK not part of the Analysis Toolpak addin :-)

Just format the cells as currency with no decimal points. It does it
automatically

"Gord Dibben" wrote:

Arvi was probably thinking of the MROUND function.

Gord

On Sat, 18 Dec 2004 20:12:04 +0100, "Frank Kabel"
wrote:

Hi Arvi
ROUNDUP is aFAIK not part of the Analysis Toolpak addin :-)

Hi


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Arvi was probably thinking of the MROUND function.

Gord

On Sat, 18 Dec 2004 20:12:04 +0100, "Frank Kabel"
wrote:

Hi Arvi
ROUNDUP is aFAIK not part of the Analysis Toolpak addin :-)

I did mean ROUNDUP - it will do for OP, but I'm now somehow confused. I'm
sure a couple of years ago I had a case, where my formula with
ROUNDUP/ROUNDDOWN function didn't work on another computer, and I had to
install something. But I have to belive you - I myself have always Analysis
Toolpack installed at very start, and I will not uninstall it to check this
out. :-)

PS. From which version on are ROUNDUP/ROUNDDOWN standard functions? I myself
use Office2000, but there exist workplaces at my work with Office97/95 too.


Arvi Laanemets

Hi
this is not the same thing as rounding :-)
Using such a format will only change the DISPLAY of your value the
underlying value still remains (that is Excel will calculate internally with
the unrounded figure)

--
Regards
Frank Kabel
Frankfurt, Germany

The Old Guy wrote:
Just format the cells as currency with no decimal points. It does it
automatically

"Gord Dibben" wrote:

Arvi was probably thinking of the MROUND function.

Gord

On Sat, 18 Dec 2004 20:12:04 +0100, "Frank Kabel"
wrote:

Hi Arvi
ROUNDUP is aFAIK not part of the Analysis Toolpak addin :-)

Hi Arvi

I did mean ROUNDUP - it will do for OP, but I'm now somehow confused.
I'm sure a couple of years ago I had a case, where my formula with
ROUNDUP/ROUNDDOWN function didn't work on another computer, and I had
to install something. But I have to belive you - I myself have always
Analysis Toolpack installed at very start, and I will not uninstall
it to check this out. :-)

PS. From which version on are ROUNDUP/ROUNDDOWN standard functions? I
myself use Office2000, but there exist workplaces at my work with
Office97/95 too.

ROUNDUP is also available in Excel 97 (without installing the ATP). Not sure
about Excel 95 though
Frank