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

percentage forumla

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Percentage forumla

Percentage forumla

ResolvedVersion 2003

Marianna has attended:
Excel Introduction course

Percentage forumla

What is the formula to calculate a percentage?

RE: Percentage forumla

Hi Marianna

I may need a bit more info to assist with this but as an example this might help:
In cell A1 i have captured a value of 9
In cell B1 I have captured a value of 10
I want C1 to show the the percentage of a1 of B1.

My formula would read =A1/B1 then format the cell to percentage.

Let me know if that helps.

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

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.