multiply several different rows in a colum beginner

[gt5228]

see attached file for example. so i have a chart. say it has 5 colums a,b,c,d,e and 3 rows 1,2,3. (it really has hunreds) all rows have different values (numbers). some rows need to be multiplied. lets say b1 is 3 and b2 is 5, and d colums are blank. what if i need to autommatically multiply each value in b colum by 2 to make d1 now have 6 and d2 to have 10? is there a way to do this without having to conditionally format each row hundreds of times?

[FDibbins]

Hi and welcome to the forum

the file you attached seems to bare no sesemblance to the example you stated above?

if you want D1 to be B1 * 2, then thats exactly how you enter it...=B1*2 you can then copy/paste that down as far as you need to

tip: if you look at the bottom right of the cell ther cursor is in (say D1) you will see the corner leeks like a small black square. If you aim the mouse at that small square, and then double-left-click on it, it will copy down to the 1st empty cell in C

[gt5228]

Thanks for saving me some time. Maybe you could answer this...? So once rows are multiplied, the prouct is multiplied by a quantity. For some reason the plank quantity cells are counted as 1 isntead of 0. I know that i can just just fill in 0 but is there a way to meke the cells in quantity colum be 0 if left blank? Ex. So b2 is 5 and c2(b2*2)is 10. D2 is left blank to be filled in with a quantity, lets say 2. Then e2 is c2*quantity(d2) giving me a total for that row. If i leave d2 blank then excel assumes its 1 and e2 is still 10. I would like e2 in this case to be 0 unless a different a quantity is added. Is this possable? I want the quantity to always return to 0 if deleted. I guess long story short i need the default value in a colum to be 0 unless a value is entered

[FDibbins]

the file you attached seems to bare no sesemblance to the example you stated above?

PLEASE upload the correct file, i am not going to guess at what data you are talking about