View Single Post
  #1   Report Post  
bob
 
Posts: n/a
Default formulas using text

hello
First i dont even know is this is possible orif i am using the right program
but...i would like to set excell for a football pool where each players pick
is matched against the outcome of that game and will enter the value win or
loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not
error proof also i would like a function add up all the win and losses to get
a win loss record for that week i.e. 11-5 if thats possible you are a god and
i am the happiest person alive
--
bob