Thread: IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alyssa Alyssa is offline
external usenet poster
 
Posts: 15
Default 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.