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.
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:
Rounds a number down to the nearest integer.
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.