Quote:
Originally Posted by Spencer101
Hi,
Try using =IF(AND(E4="",E3=""),"",IF(E4=E3,1,0))
This will show no result if both E4 and E3 are empty. Then if there is a 0-0, 1-1 etc. draw it will populate with 1 point.
For sorting the table automatically you will probably need to use some VBA. Not my strong point I'm afraid so I will leave that part of the question for someone more qualified.
Hope that helps.
S.
|
Hmm.. That's giving me a value error.
Because there are three games being played by the one team, i have set three conditions in the one cell. It goes like this:
=IF(E4=E3,1,0)+IF(H4=H3,1,0)+IF(E6=E7,1,0)
I tried editting it to what you suggested, and i get a #VALUE error :\