Forum home » Delegate support and help forum » Microsoft Excel Training and help » Rounding
|
|
|
The UK's most regular 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. |
Rounding
Resolved · Low Priority · Version 2007
Reply Wed 5 Nov 2008, 16:15Delegate Samantha said...
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.
For upcoming training course dates see: Pricing & availability
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.
|