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.

Eli W asked in Computers & InternetSoftware · 10 years ago

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

Relevance
  • 10 years ago
    Favorite 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

  • 10 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
  • Anonymous
    4 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

Still have questions? Get your answers by asking now.