Excel returning incorrect result using Int function

[laxster]

Hi all,

Excel seems to be returning the incorrect result for a few entries on my spreadsheet. We have solme calculations that are run using the INT function, and when something should mathematically be 0, it is returning to us as -1. I've attached the spreadsheet for reference, and the offending entries are F22-24.

Something simple seems to escape me, but I'm not sure what, considering the sheet works as designed for everything else.

 

[Brianwarnock]

In the 3 cases quoted the result in the D col is less than the result in the E col.


Brian

 

[pbaldy]

Take a look at the Trunc worksheet function and see if it does what you want.

 

[laxster]

In the 3 cases quoted the result in the D col is less than the result in the E col.

They all return the same value, not different ones.

 

[Brianwarnock]

They only appear to return the same value as the display is rounded but the actual values are not.
Select the cell and then click on the fx in the formula bar.

Brian

 

[laxster]

Thank you!