Hello everyone!
i want to create a formula that can work out how many pours of a 700ml
bottle you can get at 25ml a shot, at £2.00 each, cost price of the 700ml
bottle is £14.31.
so basically i want to have a sheet were i can see bottle quantity, bottle
volume, cost price, selling price, profit per bottle, then show a profit
margin on that particular product.

i have already created such a formula but when its in place it says my
profit margin on that product is 2084%
this is the formula; =IF(L22=0,0,(L22/J3))

http://www.filedropper.com/example_3

thanks, Chris