Multiplying cells automatically

[pandemonium]

So, I have an commercial invoice in Excel filled with data. The thing I want to do is to somehow automatically multiply/divide the value from E5 with D5 in a blank cell H5. That is what I want to do to the end of the invoice (the next situation would be to multiply for example E6 with D6 in H6) to the bottom for each field. What I exactly would like to do is to set a formula or anything what is possible in Excel so this can be calculated automatically for each cell to the bottom.
Any help, tips, recommandations would be appreciated.
Tnx in advance.

 

[GlennUK]

Why can't you put a formula in H5:
=IF(D5="","",E5/D5)
?
( had to guess the actual operation, as you just said multiply/divide which makes no sense )

 

[pandemonium]

Sorry if I wasnt clear enough, english is not my native language.
For Example; in my case column I is prices of a product, and column J is quantity, and in column K i want to have the product (I*J). The thing is that I need to find a way to multiply all those things somehow, but not going "step by step" writing a formula for the cell K1=I1*J1; K2=I2*J2; etc... Hope this helps to understand my problem.

Thanks again, greetings.

 

[GlennUK]

Once you have set up 5 rows in a list with formulas, then Excel will automatically add additional formulas when you add data.

 

[Peter_SSs]

Once you have set up 5 rows in a list with formulas, then Excel will automatically add additional formulas when you add data.

Provided 'Extend data range formats and formulas' has been selected in Options of course.


pandemonium

Welcome to MrExcel!

Taking another guess at what you might be after...

If you already have a lot of data in columns I and J then you can just enter the formula in K1 then select K1 and double click the Fill Handle (the little black square at the bottom right of the selection).

Provided you have no gaps in the column J values, this should copy your formula doen the whole column of data almost instantaneously.

 

[pandemonium]

Thank you very much!