how do you roud up the number in Excel please?

M

maram

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.
 
G

Gordon

maram said:
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.
Click to expand...

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

Arvi Laanemets

Hi

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

Arvi Laanemets
 
T

The Old Guy

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

Arvi Laanemets

Hi


Gord Dibben said:
Arvi was probably thinking of the MROUND function.

Gord
Click to expand...

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
 
F

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)
 
F

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.
Click to expand...

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