Tuesday, July 19, 2011

yogi_Apply Formula To Multiple Cells In A Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

lulae said:
how do i apply this formula to multiple cells in a column?
=(C3*D3)+E3
I would like the formula to apply to rows 3-50, 50 being =(C50*D50)+E50
many rows are not complete yet and it still needs to function
I tried various things but I'm not quite grasping how to write an arrayformula, assuming that is how to do
this.
----------------------------------------------------------
Yes, you indeed need an array formula ... and the following illustration will show how to use the array formula. And information if some cells is missing ... no matter -- the formulas will still work and if and when the missing information is filled-in the formulas will update themselves.