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 » Formulas
Formulas
Resolved · Low Priority · Version 2003
Fri 27 Mar 2009, 15:29Delegate Kim said...
Mon 30 Mar 2009, 15:53Trainer Carlos said...
RE: Formulas
Hi Kim
A percentage is a fraction that has been formated into a Percentage (multiplied by 100)
So to create a pecentage just divide two numbers and then format the answer using the % format. For Example:
Cell A1 = 30 and Cell B1=40
In Cell C1 enter =A1/B1
This gives a value of .75
Select Cell C1
1. Select the Format Menu and Click Cells
2. In the Format Cells dialog box under the Numbers tab Select Percent and click OK
C1 will appear as 75%
Hope this helps
Carlos
Thu 9 Apr 2009: 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:Using the Quick Access Toolbar in Excel2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
