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 » Tables
Tables
Resolved · Low Priority · Version 2007
Tue 29 Apr 2008, 16:13Delegate Katy said...
Katy has attended:
Excel Intermediate course
Excel Advanced course
Tables
How do you put something in a table that is greater than and less than then sort it out it order.
Thu 15 May 2008, 20:38Trainer Cress said...
RE: Tables
hi
Not sure i understand the question. After you put data in a table you can sort the entire table using the Sort functionality by highlighting the table and using data>>sort.
Do you mean that you want a column which is a result based on an if statement? for example a formula that says if a value is less than 5 put 'small' in the cell? This would be a formula such as:
=IF(C8<5,"Small","medium")
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:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |
