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