| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula, with constant cell, trouble with fill down | Excel Discussion (Misc queries) | |||
| Changing the fill color of a cell | Excel Discussion (Misc queries) | |||
| Fill down formula not cell content | Excel Discussion (Misc queries) | |||
| How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
Linear Mode
