This is a good solution to those times when your data has say 3 decimal points but you are showing your numbers to 2 decimal points and so your totals do not seem to add up. Excel will round the numbers to the decimal points you have shown.
Warning: remember to check that the total comes back to the number that you had in mind (if there is any cumulative rounding you may need to adjust one of your numbers somewhere along the way).
This is also really useful for SAP journal uploads where any numbers with too many decimals may be rejected.
No comments:
Post a Comment