Forum Discussion
Adding numbers that are displayed
See what I've done in the attached, in column B.
I entered your numbers in column A, but then in B used the formula: =ROUND(A1,2) so that 1.407 is itself rounded to two decimal places. That's what you need to do: change the numbers that are being added.
Otherwise, you do realize, that your first way of doing it is technically more accurate, even if it looks odd.
See what I've done in the attached, in column B.
I entered your numbers in column A, but then in B used the formula: =ROUND(A1,2) so that 1.407 is itself rounded to two decimal places. That's what you need to do: change the numbers that are being added.
Otherwise, you do realize, that your first way of doing it is technically more accurate, even if it looks odd.
Thank you mathetes I really appreciate it! I will give it a try.
