Simonrepro
asked on
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
Book1.xls
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi barry, My mistake originally but second answer sorted it out. many Thanks!
=(1-B6/B2)*100
regards, barry