Help with "Current Stock" formula

[ABG]

Good afternoon all

I hope everybody is well.

I'm currently making a sheet for our stock levels and trying to formulate it so we can type in the amount of sheds being built and it give me our current stock levels.

I'm trying to formulate Column B so that I can amend the numbers in J2 and J3 and it will deduct the necessary amounts from Column C. There will be lots more products in the actual list, but hoping to start small and build off the formula if possible.

Please see attached picture, all help greatly appreciated.

Thank you for your time!
Andrew

 

[Kerryx]

	​	​	​	​					​
	​	​	​	​					​
	​	​	​	​

Book1
	A	B	C	D	E	F	G	H	I	J
1	Prod	Stock	Mas Stock	10m	20m				Sheds	Qty
2	Screws	60	45	10	15				10m	0
3	Nails	30	5	20	25				20m	1
4	Planks	45	25	15	20
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=B2-(D2*$J$2)-(E2*$J$3)