I'm looking for a formula that can look at 2 sets of #'s and if they fit that criteria then show a "1". This is a baseball statistic for those that follow baseball it might be easier to figure out. I'm looking for a formula that calculates "quality starts". A quality start is when a starting pitcher pitches at least 6 full innings & gives up 3 or less runs (earned runs).
I created a file that has some dummy information.
For non baseball people I need a formula that will populate a "1" every time column A is 6 or greater & column B is 3 or less.
Thanks
Bookmarks