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?
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
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.