Hi all,

I'm new to the forum.

Could anybody help me to figure out how to count innings pitched in Excel?

Let's say I'm counting the innings pitched in the A1 column and individual games are listed in B1:B10.

I've found a couple of tips in the internet, but they don't seem to work.

To those who are not familiar with how innings pitched in baseball are calculated, they go by retired batters so two complete innings and one retired batter in the third inning amount to 2.1 innings pitched.

So basically I need Excel to roundup to the next rounded number after .2

e.g. 1.2 + 1.1 = 3.0