Rounding down not up

You have a few options

1 - you can use "Precision as Displayed" option - but this is not generally advised
http://support.microsoft.com/kb/214118

2 - you can adjust either your 3-cells or your "final calculation" to use only the Integer value of each.

In terms of adjusting the 3 cells directly:

=INT(1000/6.7)

or

=ROUNDDOWN(1000/6.7,0)

or

=FLOOR(1000/6.7,1)
*FLOOR is useful where the significance is something other than 1,10 etc...)

In terms of leaving those three cell as they were and adjusting only the final calculation:

=SUMPRODUCT(INT(A1:A3))

where A1:A3 are the three cells in question.


On a final note: please PM a Moderator and ask your thread be moved to an appropriate forum.