How are you rounding? post the formula.

One possibility you have (say) 8.49 in a cell and are formatted to show 1
decimal place. Excel will display 8.5 but the real value remains as 8.49.

If we round this

=round(a1,0)

Excel worls on the 'real' value of 8.49 and round down to 8
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"school girl" wrote:

While using Excel, I find that the system isn't rounding appropriately to
whole numbers - i.e., 84.5 becomes 84 - when it should be 85.

Any help would be appreciated!