Hi Bhavesh

You may find that 2 is not really 2 but 1.99999999999 and it is rounded for
the display.

You could try expanding the format to 0.000000000000000000 to see what you
get or do the following:

[M11]=round(m10/m1,2)

and see what the answer is.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Bhavesh" wrote:

Hi

I have this odd problem with INT function returns 1, when it needs to return
2.

i have a cell (M10) value £0.04 based on a formula
=$B3-SUMPRODUCT(($C3:L3)*($C$1:L$1)) and cell M11 value 2 based on a formula
=M10/M1.

The cell M12 =INT(M11) returns 1 but it should return 2 because =Int(2)
returns 2

Is anyone can explain me why this happening and what is workaround to fix
this issue?

If anyone would like have a look at the excel file, then i'm happy email over.

Regards
Bhavesh