how do you roud up the number in Excel please?

[Guest]

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.

 

[Gordon]

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?

 

[Guest]

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

or

=CEILING(A1,1)

tj

 

[Arvi Laanemets]

Hi

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

Arvi Laanemets

 

[Frank Kabel]

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

 

[Gord Dibben]

Arvi was probably thinking of the MROUND function.

Gord

 

[Guest]

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

 

[Arvi Laanemets]

Hi

Arvi was probably thinking of the MROUND function.

Gord

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

 

[Frank Kabel]

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)

 

[Frank Kabel]

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