How to write an excel formula to autocalculate ?

[MrNewExcel]

Pls help. I like to create a formula but I don't know how to input the correct formula.

What i like is to have a formula that will automatically calculate defending to which gasoline product i choose to consume and automatically sum up, if how much i consume on each product.
Pls. see my excel example and picture.
Never mine the colors, i just highlighted for easy reference. Thank you.

GAS PRODUCT MONITOR.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	ENGINE NO.1 CONSUMPTION								ENGINE NO. 2 CONSUMPTION								ENGINE NO. 3 CONSUMPTION (ALWAYS IN PETRON)						OIL Consumption			Consumption (Total)
2	Counter	Density	Temp	[ltr.]	Cons.	SHELL	PETRON	CALTEX	Counter	Density	Temp	[ltr.]	Cons.	SHELL	PETRON	CALTEX	Counter IN	Counter OUT	Density	Temp	[ltr.]	Cons.	Counter	LBS	OHS	SHELL	PETRON	CALTEX
3	69868800	0.9800	130	900	0.8	X			11134700	0.9900	92	900	0.8	X			7979820		0.9800	130	160	0.1	1436690		10	=1.6 (0.8+0.8)	=0.1
4	69869300	0.9800	130	500	0.5			X	11135150	0.9900	92	450	0.4	X			7979930		0.9800	130	110	0.1	1436700		10	=0.4	=0.1	=0.5
5	69869600	0.9800	130	300	0.3			X	11135640	0.9900	92	490	0.5			X	7980020		0.9800	130	90	0.1	1436710		10		=0.1	=0.8
6	69869700	0.9800	130	100	0.1		X		11136270	0.9900	92	630	0.6		X		7980200		0.9800	130	180	0.2	1436710		10		=0.9 (0.1+0.6+0.2)
Sheet1

Cell Formulas
Range	Formula
E3:E6,V3:V6,M3:M6	E3	=ROUND((B3-0.000625*(C3-15))*D3/1000,1)
L4:L6,D4:D6	D4	=IF(A4>0,A4-A3,0)
U4:U6	U4	=IF(Q4>0,(Q4-Q3)-(R4-R3),0)

 

[Fluff]

Duplicate to: how create a formula that is autocalculate?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.