# Any idea how to do this?

#### agonysWeeper

##### Board Regular
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.

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Try =INT(99/A1)

Or another way in C1:

=FLOOR(99/A1,1)

Hi tweedle and Nalani, thanks, its working.

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

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

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

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.

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)

Replies
5
Views
195
Replies
2
Views
84
Replies
6
Views
297
Replies
4
Views
309
Replies
14
Views
881

1,218,835
Messages
6,144,749
Members
450,567
Latest member
Mplz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back