Fill down formula (but changing cell value by two)

J

jbly

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

jbly

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top