Sum Required Excel 2003

I am after a sum to replace the text I have put in row 7 that gives me the same result please.
Book1.xls
SimonreproAsked:
Who is Participating?
 
barry houdiniCommented:
But I thought you want the results as shown in your workbook - you have 40 in B7? If you just want GP as a percentage of sales then this formula will give you 40

=100*B6/B2
0
 
barry houdiniCommented:
I'm not 100% sure of the requirement, perhaps this formula in B7 copied across

=(1-B6/B2)*100

regards, barry
0
 
SimonreproAuthor Commented:
Hi Barry,  I don't think this is right as if my sales are £100 and my GP is £60, then my GP % would be 60% but your calculation makes it 40% GP?
0
 
SimonreproAuthor Commented:
Hi barry, My mistake originally but second answer sorted it out.  many Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.