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 » Excel
Excel
Resolved · Low Priority · Version 2003
Thomas has attended:
Excel Intermediate course
Excel
what is the nested function?
how do i remember all this?
RE: excel
Hi Thomas
A nested function is uses the results of another function for its data. For example you might use one function (Round) to modify the results of a Sum function. It would look like this:
=ROUND(SUM(A1:A5),1)
The key to remembering features such as this is to keep applying them - plus you also now have access to our support forum for a year if you need any reminders.
Good luck with Excel and do let us know if you have any further questions.
Kind regards,
Andrew
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:Add Text to Displayed Numbers in Excel 2010To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text! |