Hello,
I am in need of a couple formulas that allows me to alternate between odd and even cells that contain a merged cell within the formulas.
1) Every two rows in the F column is a merged cell. Column H is not merged. I need my formula to multiply every value in the H column by a value in the F column. Below is an example of how I would need my formulas to be down "I":
=F17*H17
=F17*H18
=F19*H19
=F19*H20
=F21*H21
=F21*H22
and so on.....
I tried to do the formula =IF(ISODD(ROW()),F17*H17,F18*H18) but every even row would select the "blank" row of the merged cell in column F, instead of selecting the value of the merged cell.
2) Similarly, both column D and column F are merged cells, whereas column K is not merged. Below is an example of how I would need my formulas to be down "L":
=D17*K17
=F17*K18
=D19*K19
=F19*K20
=D21*K21
=D21*K22
and so on...
Please help! I need this by tomorrow morning Pacific time.
Thank you in advance!
Bookmarks