This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I have a problem I haven't been able to figure out.
In baseball, there are three outs in an inning. If a pitcher pitches two full innings and during the next inning he gets two batters out, his innings pitched total is expressed as 2.2 or two and two-thirds innings. This is a problem for me if I ever have to do some calculation involving innings pitched and then put it back in that format.
First I'll use the dollarde function to change 2.2 into 2.6667. Then I'll do some kind of math with it. Far more often than not I'll end up with a figure like 6.89 for innings pitched. If I use dollarfr to attempt to change that to 7.0 innings, it returns 6.3 innings instead.
I'm looking at a sheet I have open right now. I have the figure of 6.148 and dollarfr correctly changes that to 6.0. However, I have another cell with the value 5.819 and it changes that to 5.2, whereas in my opinion it should round that all the way to 6.0. It will round down sometimes to .0 innings, but will never round up to it. I have 5.895 or 5.87....both of those go to 5.3
dollarfr is either not the function to use, or I'm not using it correctly. How should I go about this?
Thank You. I hope my post makes sense.
Edit: I'm stuck with Excel 2007 but sometimes use Calc (either OpenOffice or LibreOffice).
Subreddit
Post Details
- Posted
- 9 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...