Trying to put text in on a condition

  • Thread starter Thread starter Johnny
  • Start date Start date
J

Johnny

Thanks in advance...
I have 2 formulas I need help with.
1) How do I write if d3<d5 display contents of d2 else
display contents of d4?
2) Then on another page I want it to look to see if d2:d60
= Team1 then display how many times it is present.
 
Thanks for your help but I forgot to mention another
condition and that is if they have no value, then no
display or if they = each other display TIE.
=IF(D3<D5, D2, D4) AND D3=D5 and they are > 0 display TIE
else display nothing. I then subsequentially would NOT
want =COUNTIF(Sheet2!D2:D60, "Team1") to count a TIE
Thanks very much as I am doing the scoring for our local
Little League and this is going to be a timesaver...
 
VERY COOL!!!
Thanks very much. I still have the tally sheet to figure
out but I think you've given me enough to go on...
Thanks again!

-----Original Message-----
Left out the =0:

=IF(SUM(D3,D5)=0,"",IF(D3=D5,"TIE",IF(D3<D5,D2,D4)))
Click to expand...
 
Back
Top