Q: How to make "whole" numbers?

[Tom H. Lautenbacher]

Hello NG,

i want to tell excel, to make out of a number e.g. 5,93 a "whole number" (as
we call it in german), wich in this case would be 5.
please don't mix it up with ROUND. round would have made a 6 out of it.
what i want, is that all these numbers e.g.
5,01
5,45
5,9

would be turned into a 5

thanx in advance,
Tom.

 

[Ron Rosenfeld]

Hello NG,

i want to tell excel, to make out of a number e.g. 5,93 a "whole number" (as
we call it in german), wich in this case would be 5.
please don't mix it up with ROUND. round would have made a 6 out of it.
what i want, is that all these numbers e.g.
5,01
5,45
5,9

would be turned into a 5

thanx in advance,
Tom.

=INT(5,93) = 5


--ron

 

[Norman Harker]

Hi Tom!

With a number in A1:

=ROUNDDOWN(A1,0)
=INT(A1)
=TRUNC(A1,0)

Test carefully to see that you get what you want with negative
numbers.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Saturday 26th July: Andorra (Sant Julia De
Loria), Argentina (Eva Peron Day), Brazil (Day of Iansa), Cuba (Anniv
of the Moncada Barracks Attack Day), Haiti (Gran’Delai et Gran’
Aloumandia (Sainte Anne), Liberia (Independence Day), Maldives
(Independence Day), USA (New York State Ratification Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Peo Sjoblom]

=INT(A1)

=TRUNC(A1)

in German

=GANZZAHL(A1)

=KÜRZEN(A1)

difference is that with a negative number (lets say -2.3)
int will return -3 while trunc will return -2 thus int rounds
down.

 

[CLR]

=ROUNDDOWN(A1,0)

Vaya con Dios,
Chuck, CABGx3

 

[Tom H. Lautenbacher]

<many good answers>

thanx everyone!!

tom