Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel "IF" Function Question?
Here's what I'm trying to do:
I'm logging a pitcher's pitches at a baseball game. I have the count and pitch type to record, but I'm trying to put together a "summary" chart that shows how much a certain pitch is thrown on a certain count.
For example: I want to record how many fastballs/changeups/curveballs he throws on a 0-0/1-0/3-2 count.
Right now, I have a column for count starting with Column C row 3. The column next to it is pitch type, Column D row 3.
I've entered the following function:
=IF(C3:C150="0_0",COUNTIF(D3:D180,"FB"))
Where the first part determines the count, and the second part determines the pitch type.
The problem is that the range portion (C3:C150) is not working properly. If I enter a 0-0 count, the value is not returned. I think it has something to do with using the range of cells in an if function. Again, what I'm trying to do is look at each count, and then record what pitch was thrown in that situation throughout the game. How can I resolve this so that it will work as I want it to? Thanks.
3 Answers
- Laurence ILv 710 years agoFavorite Answer
you need a logical expression for the first part ie a true false result
maybe if you nest another if
=IF( if(c3:c150=.....), countif
see excel help
list logical IF function
then click more help
then see examples
- ScrawnyLv 710 years ago
I would enter the data, one row per pitch and then use a Pivot Table to summarize the data. It does a better job than trying to analyze using a bunch of formulae. Take a look for Pivot Table in the help file to see what I mean.
Source(s): Experience - Anonymous4 years ago
right here it is in Excel 2007 version, you didnt specify which version you have been using, in case you prefer it in an older version, replace slashes with semicolon =IF(B8<50000/B8*0,05/IF(50000<B8<ten thousand... considering the fact that its not showing the entire formula, i inserted some areas, basically delete them =IF(B8<50000/B8*0,05/ IF(50000<B8<a hundred thousand/B8*0,03/ IF(B8>=a hundred thousand/B8*0,01))) they're 3 if instructions. basically such as you published it