Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formulas

ResolvedVersion 2003

Kim has attended:
Excel Introduction course

Formulas

How do I work out percentages?

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.