vba to make multiplication to specific headers

[RAM72]

Hi

Looking vba t o make multiplication calculation from specific headers .

The situation is follows for header litres(q) check qty columns (k) , multiply it to header L and M .

The second situation is a bit tricky

either lookup in column i or J , is there is data in I ,then multiply to columns q (litres)and fill column m

otherwise lookup in j , multiply column L and insertdata in column N to 3 decimal places

If there is no data in column G and H , then do nothing

 

[Hui]

L2: =K2*H2
M2: =Iferror(L2*I2,0)
N2: =L2*J2

The apply a custom Number Format to L2:M2 of #,###;-#,###;;@
then apply a custom number format to N2 of #,###.###;-#,###.###;;@
Then copy L2:N2 down to Row 42

see attached file:

Note you have errors in your data in I41:I42