Calculating profits

The UK's most regular instructor-led training courses.
Training information: application development excel · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · High Priority · Version 2007

Calculating profits

Michael has attended:
Excel Introduction course

by - delegate Michael [1 post] (2008 Jun 18 Wed, 16:42) Reply

How to calculate %

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: calculating profits

by - trainer Amanda diamond contributer [1298 posts] (2008 Jun 20 Fri, 10:44) Reply

Hi Michael

Thank you for your question; and welcome to the forum.

To create a percentage, you need to have a value; and an overall total.

For example, if you had sales for each quarter then an overall total for the whole year, you would create a formula that takes the figure for say, quarter 1, and divides this figure by the overall total.

Type in = first, then select the figure for quarter 1, type in / and then select the overall figure. Press Enter.

You will get the result as a decimal to start with. If you select the cell showing the decimal result, then go to Format - Cells - Number tab. Select Percentage from the categories on the left, set how many decimal places you would like displayed on the right, and click OK. Your result should show as a % now.

I hope this helps.
Amanda