Excel baseball spreadsheet

[logan82]

I was wondering if anybody knew a good way to add up innings without having to round and go into messy if then statements. For example adding 6.1, 7.2, 5.1, and 7.2 and getting 27. I know I can put them at 1/3 and stuff, but I would prefer to put them in as decimals.

 

Edit: Here is what I have right now

 

=(A1-ROUND(A1,0))*1/3*10+ROUND(A1,0)

[rluzinski]

Nice solution. I just don't usually bother because it requires an extra column.

[logan82]

Nice solution. I just don't usually bother because it requires an extra column.

Thank you. It started out as a long if,then,else with that equation as the else, but after thinking about it if there isn't a decimal it wouldn't change the end result so it was unnecessary.