Microsoft Excel

One night I was working on an awesome MS Excel spreadsheet. We play the card game 500 with our friends, The Benson's (confused?). In the game, you play to 500 points but we keep running point total since 2010. I was revising the spreadsheet to make it more user friendly. I had a formula question for the hubby. He said he would help. I come back from the bathroom and he's going to town, exceling it up:

One of the formulas looks like this:
=IF(OR($C34=$C$2,$C34=$C$3),IF(ISNUMBER(VALUE(LEFT($B34,1)))=TRUE,IF($D34>=IF(LEFT($B34,1)="1",10,VALUE(LEFT($B34,1))),INDEX($E$2:$E$23,MATCH($B34,$B$2:$B$23,0)),-INDEX($E$2:$E$23,MATCH($B34,$B$2:$B$23,0))),IF($D34>0,-INDEX($E$2:$E$23,MATCH($B34,$B$2:$B$23,0)),INDEX($E$2:$E$23,MATCH($B34,$B$2:$B$23,0)))),IF(ISNUMBER(VALUE(LEFT($B34,1)))=TRUE,(10-$D34)*10,$D34*10))
Hours later, we have a pretty cool spreadsheet that minimizes data entry errors, graphs important stats and summarizes the total. Thanks, Dave!