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 » Introduction to Excel
Introduction to Excel
Resolved · Low Priority · Version 2003
Wed 10 Mar 2010, 16:31Delegate Ann said...
Ann has attended:
PowerPoint Introduction course
Excel Introduction course
Introduction to Excel
when you have taken out the decimal point does the figure round up and round down
Thu 11 Mar 2010, 10:42Trainer Simon said...
RE: Introduction to Excel
Hi Ann,
Thank you for your question.
When you decrease the number of decimal places to zero, if the answer was 0.654, then Excel would round the figure up to 1 as the number after the decimal is 5 or above.
However if the answer was 0.45 then Excel would round that down to 0.
So even though 0 is displayed that actual answer is 0.4.
I hope this answers your question.
Regards
Simon
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:Screen Splitters in ExcelScreen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter. |
