# 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

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

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

??

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

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

One way...

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

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

A few keystrokes shorter...

=(A2>=6)*(B2<=3)

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!

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

You're welcome. Thanks for the feedback!

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1