Thanks for your replys,

In the event that there is a guy on 2nd, and a single is hit, the player will advance only the number of bases of the hit; so there would be players on 1st and 3rd. So I need to find a formula to calculate this, which I'm stumped on. Maybe some of you advanced users know a way?

I will have to try and change the format if there isn't a way, but I still need the data to all be in one string, I was thinking like:

STR0102

'STR' is the pitch type
'010' would be who's on base, the first digit would be 1st base, next would be 2nd, and then 3rd for the third digit
'2' would be the play, a double for example

So I would go through a formula for '010' like:

IF(0*1 > 0, 1 + 2, 0) - 0*1, the 0 would be a 1 if someone was on base
IF(1*2 > 0, 2 + 2, 0) - player was on 2nd, so 2+2 = 4, meaning he scored
IF(0*3 > 0, 3 + 2, 0)

Would this work or is it flawed?

THANKS!