Diana has attended:
No courses
Excel addition
I have a list of numbers to total, the cells only show whole numbers as the format as requested no decimal places.
I would like the addition at the bottom of the list to add up the rounded up/down numbers and ignore the decimal places. ie
98.90 99
33.45 33
33.43 33
24.40 24
190 189
In otherwords I would like the answer in the first column to come out as 189 rather 190.
I hope I am explaining myself acurately?
RE: Excel addition
Dear Diana
Thank you for your question.
It is possible to do what you want to achieve.
Please remember that by increasing or decreasing decimal places you are only changing the format or appearance of the numbers in the cells. It doesn
RE: Excel addition
Dear Diana
Sorry I forgot to mention that once you have got the result you may want to hide the original column with decimal places.
Please do not Delete it as Colum B depends on it!!
I hope it makes sense!! :)
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
