Round Numbers

[Guest]

I would like to know if there is a way to identify round/integer numbers.
EG:

invoice amount

1 34345.5
4 324.45
6 100
7 200

Thanks for any help

 

[Guest]

What do you want them to round to?
There are numerous formulas to help:
ROUND

 

[Guest]

If you want to round to the nearest integer, one way:

=ROUND(A1,0)


Replied prematruely there ...
Numverous functions to round (this list is not exhaustive):
ROUND
ROUNDDOWN
ROUNDUP
FLOOR
CEILING
INT

Check out the Help filels by Function name.

tj

 

[Bob Phillips]

take a look at http://www.xldynamic.com/source/xld.Rounding.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

I would like to know if there is a way to identify round/integer numbers.
EG:

invoice amount

1 34345.5
4 324.45
6 100
7 200

Thanks for any help

=A1=INT(A1) will --> TRUE if the number is an integer.


--ron