how create a formula that is autocalculate?

[MrNewExcel]

PLS HELP. I LIKE TO CREATE A FORMULA BUT I DON'T KNOW
HOW TO INPUT THE CORRECT FORMULA.

WHAT LIKE IS TO HAVE A FORMULA THAT WILL AUTOMATICALLY
CALCULATE DEFENDING TO WHICH GASOLINE PRODUCT I
CHOICE TO CONSUME AND AUTOMATICALLY SUM UP, IF HOW MUCH
I CONSUME ON EACH PRODUCT.
NEVERMINE THE COLORS, I JUST HIGHLIGHTED FOR EASY
REFFERENCE.PLS CHECK THE PICTURE OF MY ACTUAL SHEET.THANK YOU.

 

[Peter_SSs]

Please review #14 of the Forum Rules about not using excessive amounts of upper case writing.

Also, you are more likely to get a fast (& good) response if you provide your sample data in a form that helpers can easily copy to test with - not possible from a picture. To help, MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[MrNewExcel]

Please review #14 of the Forum Rules about not using excessive amounts of upper case writing.

Also, you are more likely to get a fast (& good) response if you provide your sample data in a form that helpers can easily copy to test with - not possible from a picture. To help, MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Thank you for the response. I will rewrite my post.

 

[MrNewExcel]

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)