98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Excel addition
excel training class - Excel addition
Resolved · Low Priority · Version Standard
Fri 18 Jan 2008, 15:54Delegate Diana said...
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?
Sat 19 Jan 2008, 02:24Trainer Rajeev said...
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
Sat 19 Jan 2008, 02:28Trainer Rajeev said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Changing the Tab Colour of an Excel 2010 WorksheetDid you know you could give the tabs in your worksheet different colours? |
