98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Rounding
Rounding
Resolved · Low Priority · Version 2007
Samantha has attended:
Excel Advanced course
Excel Advanced course
Rounding
When using ROUND formulas, how do you type the formula for the folling scenario: Rounding down from 21.5 to 21. -1 rounds down to 20.
RE: Rounding
Hi Samantha
Sorry i haven't got back to you before now
the way for you to be doing what you are looking for would surely be the way you have displayed above as i did this myself as to the decimal places what you would need to do is decrease the places the format shows to no places
Hope this helps
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Mon 1 Dec 2008: Automatically marked as resolved.
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:Return to the active cell after scrollingWhen I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen. |