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
Excel
Resolved · Low Priority · Version 2003
Wed 22 Oct 2008, 15:57Delegate Olga said...
Tue 28 Oct 2008, 13:56Trainer Laura said...
RE: Excel
Hi Olga
Thank you for your question and welcome to the forum.
The Round function will round a number to a given number of decimal places.
If A1 contains 1234.567
Then =Round(A1,2) returns 1234.57
And =Round(A1,0) returns 1235
A slightly different use is to round to hundreds or thousands using negative as the number of places.
So =Round(A1,-3) would return 1000.
I hope that explains it.
Laura GB
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:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
