Calculating profits

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