Thanks:  0
Likes:  0

# Thread: Help with "If greater than, but less than" statement.

1. ## Help with "If greater than, but less than" statement.

Hi, all - I have been banging my head on the desk over this one...it's gotta be so simple, right? Have searched online, and on Mr. Excel, but still can't get this right.

I need a formula in cell L3 that says "IF cell K3 is greater than 25 but less than 30, K3, otherwise, blank." Cell K3 currently contains the value 30. My formula in L3 currently is =IF(K3>25,K3,IF(K3<30,K3," ")). Cell L3 is displaying 30...so the formula isn't working the way I need it to.

2. ## Help with "If greater than, but less than" statement.

Try:
Code:
`=IF(AND(K3>25,K3<30),K3,"")`

3. ## Re: Help with "If greater than, but less than" statement.

Huzzah! Thanks, JackDanIce!

I knew the solution would be simple, and I even thought it might use AND, but it seemed everything kept pointing to nested IF statements...so I never quite got there.

Very grateful!

4. ## Re: Help with "If greater than, but less than" statement.

You're welcome

## User Tag List

#### Posting Permissions

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