Fill down formula (but changing cell value by two)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbly - 21 Mar 2008 04:32 GMT

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(E3>F3,C3,IF(E3="","",D3))
C34=IF(E5>F5,C5,IF(E5="","",D5))
D33=IF(E4>F4,C4,IF(F4="","",D4))
D34=IF(E6>F6,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?

Reply to this Message

David Biddulph - 21 Mar 2008 09:44 GMT

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)))

Signature

David Biddulph

>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:
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

jbly - 21 Mar 2008 21:49 GMT

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

> 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)))
[quoted text clipped - 6 lines]
> > 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?

Reply to this Message