Any idea how to do this?

[agonysWeeper]

I have image below which is C1 and D1 has the formula, the formula for C1 is simply =99/A1 then the result 1.8, what I need is just the whole number 1, I want those decimal point ".8" will removed. any one can help me out of here? thanks.

 

[tweedle]

Try =INT(99/A1)

 

[Nalani]

Or another way in C1:

=FLOOR(99/A1,1)

 

[agonysWeeper]

Hi tweedle and Nalani, thanks, its working.

 

[Peter_SSs]

If you want to simply chop off the decimal part then there is
=TRUNC(A1/99,0)
or just
=TRUNC(A1/99)
since the default number of decimal places for TRUNC is 0.

This could be relevant to you if it is possible that the value being shortened (99/A1 in your case) is negative. For example,
=INT(-7.2) = -8
=FLOOR(-7.2,1) = -8
but
=TRUNC(-7.2) = -7

 

[agonysWeeper]

I don't understand why =INT(-7.2) show the answer -8
while =TRUNC(-7.2) is -7. I did a simply =(-7/2) then the answer is "3.5" so means the INT rounded it off "4" while TRUNC just rounded it off "3".

 

[agonysWeeper]

Alright, I think "TRUNC" is more okay.
=TRUNC(99/-7) = -14
=INT(99/-7) = -15
=(99/-7) = 14.14285714 (basic)

 

[Peter_SSs]

I don't understand why =INT(-7.2) show the answer -8
while =TRUNC(-7.2) is -7. I did a simply =(-7/2) then the answer is "3.5" so means the INT rounded it off "4" while TRUNC just rounded it off "3".

People are often misled by the name of the INT() function. INT is short for integer but it is because the function returns an integer, not because it returns the integer part of its argument. From the Help on INT:

Description
Rounds a number down to the nearest integer.

So rounding -7.2 down to the nearest integer gives -8.


Whereas for TRUNC():

Description
Truncates a number to an integer by removing the fractional part of the number.

 

[Dryver14]

I don't understand why you are questioning the maths when in your original post you said you wanted 1.8 to be 1 which surprised me if you wanted it to be above 0.5 to read up or below 0.5 to read down then
the round function would ahve worked.

=ROUND(C1)