S Steve Davey Mar 12, 2005 #1 Can anybody tell me the best formula to use to calculate the profit margin between two number when this maybe plus or minus
Can anybody tell me the best formula to use to calculate the profit margin between two number when this maybe plus or minus
N Nick Hodge Mar 12, 2005 #3 Steve I use =1-(Buy/Sell) You could use =(Sell-Buy)/Sell -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
Steve I use =1-(Buy/Sell) You could use =(Sell-Buy)/Sell -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
