Round Numbers

S

Stefano

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
 
T

tjtjjtjt

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
 
R

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

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


--ron
 
Top