ExcelBanter - Fill down formula (but changing cell value by two)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fill down formula (but changing cell value by two) (https://www.excelbanter.com/excel-discussion-misc-queries/180858-fill-down-formula-but-changing-cell-value-two.html)

jbly

Fill down formula (but changing cell value by two)

I have the college basketball pool entered. I want to have it fill in the
winners into the appropriate cell. I have the following, which works:
C33=IF(E3F3,C3,IF(E3="","",D3))
C34=IF(E5F5,C5,IF(E5="","",D5))
D33=IF(E4F4,C4,IF(F4="","",D4))
D34=IF(E6F6,C6,IF(F6="","",D6))
However, when I fill down it wants to add one to each cell value when I
really want it to add two. How do I get this to fill in correctly?

David Biddulph[_2_]

Fill down formula (but changing cell value by two)

For you C33 formula, try
=IF(OFFSET(E$3,2*(ROWS(C$33:C33)-1),0)OFFSET(F$3,2*ROWS((C$33:C33)-1),0),OFFSET(C$3,2*(ROWS(C$33:C33)-1),0),IF(OFFSET(E$3,2*(ROWS(C$33:C33)-1),0)="","",OFFSET(D$3,2*(ROWS(C$33:C33)-1),0)))
--
David Biddulph

"jbly" wrote in message
...
I have the college basketball pool entered. I want to have it fill in the
winners into the appropriate cell. I have the following, which works:
C33=IF(E3F3,C3,IF(E3="","",D3))
C34=IF(E5F5,C5,IF(E5="","",D5))
D33=IF(E4F4,C4,IF(F4="","",D4))
D34=IF(E6F6,C6,IF(F6="","",D6))
However, when I fill down it wants to add one to each cell value when I
really want it to add two. How do I get this to fill in correctly?

jbly

Fill down formula (but changing cell value by two)

Excellent, exactly what I needed. Thanks so much. I'll breakdown your formula
so I understand what the function is doing.

"David Biddulph" wrote:

For you C33 formula, try
=IF(OFFSET(E$3,2*(ROWS(C$33:C33)-1),0)OFFSET(F$3,2*ROWS((C$33:C33)-1),0),OFFSET(C$3,2*(ROWS(C$33:C33)-1),0),IF(OFFSET(E$3,2*(ROWS(C$33:C33)-1),0)="","",OFFSET(D$3,2*(ROWS(C$33:C33)-1),0)))
--
David Biddulph

"jbly" wrote in message
...
I have the college basketball pool entered. I want to have it fill in the
winners into the appropriate cell. I have the following, which works:
C33=IF(E3F3,C3,IF(E3="","",D3))
C34=IF(E5F5,C5,IF(E5="","",D5))
D33=IF(E4F4,C4,IF(F4="","",D4))
D34=IF(E6F6,C6,IF(F6="","",D6))
However, when I fill down it wants to add one to each cell value when I
really want it to add two. How do I get this to fill in correctly?

All times are GMT +1. The time now is 10:48 AM.