New to formulas

[Totallylost]

Hi.
Due to a recent health issue I have had to create a spread sheet for Fat and Salt content in foods, however I have absolutely no idea on how to create a formula to change a value in one field that then multiples the values in other fields on the same row.
Example. Cell 1 contains quantity, then cells 2, 3, 4 and 5 contain the contents values for that single item, what I am after creating is a formula that when I alter cell 1 to increase or decrease the other 4 cells reflect the increase or decrease of that gain/loss.
Sorry I am a real newbie at this having not used excel in over 15 years. Any help will be appreciated.
Thanks
Rich

 

[etaf]

you can make new columns to add the totals into
if you want the values to change in the cell you would need vba

so you would multiply cell 1 by cell2 , 3, 4 ,5
like this

cell with quantity * cell2
=$A2*B2

Book1
	A	B	C	D	E	F	G	H	I	J
1	quantiy	1 per item	2 per item	3 per item	4 per item		total for 1	total for 2	total for 3	total for 4
2	1	1.2	3.2	6.1	3		1.2	3.2	6.1	3
3	2	1.2	3.2	6.1	3		2.4	6.4	12.2	6
4	10	1.2	3.2	6.1	3		12	32	61	30
Sheet1

Cell Formulas
Range	Formula
G2:J4	G2	=B2*$A2

 

[Snakehips]

Rich.
Very similar here. Only a guide.
You will need a reference table that suits your way of working.

MayMrXL.xlsm
	A	B	C	D	E	F	G	H
1			Gram Per Portion				Reference g/100g
2	Food Item	Portion gm	Fat	Salt	Other		Fat	Salt
3	Food 1	75	18.75	2.25	54		25	3
4	Food 2	50	7	3	40		14	6
5	Food 3	420	252	8.4	159.6		60	2
Sheet15

Cell Formulas
Range	Formula
C3:D5	C3	=$B3/100*G3
E3:E5	E3	=B3-SUM(C3:D3)

Hope that helps