# If X is equal or less & Y is equal or greater then Show "1"

1. ## If X is equal or less & Y is equal or greater then Show "1"

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  Register To Reply

2. ## Re: If X is equal or less & Y is equal or greater then Show "1"

=if(and(a1>=6, b1<=3), 1, 0)

??  Register To Reply

3. ## Re: If X is equal or less & Y is equal or greater then Show "1"

Try this

Formula:  `Please Login or Register  to view this content.`

 v A B C 1 IP ER QS 2 6 3 1 3 7 3 1 4 5 0 5 7 2 1  Register To Reply

4. ## Re: If X is equal or less & Y is equal or greater then Show "1"

One way...

=--AND(A2>=6,B2<=3)  Register To Reply

5. ## Re: If X is equal or less & Y is equal or greater then Show "1"

A few keystrokes shorter...

=(A2>=6)*(B2<=3)  Register To Reply

6. ## Re: If X is equal or less & Y is equal or greater then Show "1"

Thank you all!

Alkey. I Understand your formula except for the 0 at the end. The 1, makes sense but why is there a 0?

EDIT: Ah, looks like you put whatever # you want to show up when it doesn't meet the match!  Register To Reply

7. ## Re: If X is equal or less & Y is equal or greater then Show "1"

You're welcome. Thanks for the feedback!   Register To Reply