Calculating Percentages

[Paul M]

I have a worksheet where I am trying to calculate a percentage value. The cells are as follows
Cell A1 is Item Description
Cell B1 is Purchase Cos
Cell C1 is Cost of Sales at 8% =SUM(B1)*8
Cell D1 is Retail Pric
Cell E1 is Profit =SUM(D1)-B1-F
Cell F1 is Profit %

Can anyone help me with the formula for calculating the profit percentage in cell F

Thank
Paul M

 

[Michael]

Hi Paul
Firstly, I think your formula in E1 is incorrect.
Shouldn't it be =D1-C1-B1 ??

If that is the case, Try this in F1

=E1/(B1+C1)


Regards
Michael

-----Original Message-----
I have a worksheet where I am trying to calculate a

percentage value. The cells are as follows: