IF Function
I am trying to creat a worksheet to automatically calculate our football
picks. So far, I have our teams listed in the first column, each in their
own row (A3 - Indy, A4 - New Orleans). B3 would be the winner (Indy) Column
C - is the person's pick (C3 = 0, C4 = 6)
I entered this IF Function =IF(A3=B3,C4,C4) So in this case it returns
6. Which is right; however I am trying to have it return 0 if I have not
entered a winner yet? Any suggestions would be greatly appreciated.
|