Link to home
Start Free TrialLog in
Avatar of Simonrepro
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
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

I'm not 100% sure of the requirement, perhaps this formula in B7 copied across

=(1-B6/B2)*100

regards, barry
Avatar of Simonrepro
Simonrepro

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
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi barry, My mistake originally but second answer sorted it out.  many Thanks!