excel percentages

[missesbell]

Am trying to do an excel sheet to include a column showing profitability but
can't even get my head around the maths to set up the formula!!!

If I have an item that I buy at �10.20 and sell at �13.20 the profit is
obviously �3.00 but how do I work out the % profit?!?!?!?!?!?

[squarebear]

I don't really know excel but I would imagine the formula would need to be something like:

percentprofit = (profit / cost) x 100

So it would be:

(3.00 / 10.20 ) x 100 = 29.4%

[Cheeris]

Depends on whether you want to work out the % profit on the cost (i.e. �10.20) or the % profit made on the sale (�13.20.

Either way, the clearest way is this. If you enter the cost in a cell in column A and the sale price in column B in column C calculate the straight profit by typing in the box

=B1-A1

When you press enter it should calculate '3' as the staright profit. In column D calculate the profit by entering

=(C1/B1)*100

This is to calculate the % profit on the sale price, to calculate the % profit on the cost substitute A1 for B1 in the above expression.

[missesbell]

Thank you so much