B
Bhavesh
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
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