I'm sure there is a simple way to do this.
I have 300 rows in a spread sheet. in column h, I want to multiply the column D number by the Column F number (so for row 3 it would be =D3 * F3) The problem is I do not want to have to put this function in each row individually, having to change the row number in each row. Is there a way to format the whole column (H) so that the figure in column H on each row is the product of column D multiplied by column F?
Thanks,
JB
Bookmarks