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

[servcoor]

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.

Thanks in advance!

 

[JackDanIce]

Try:

=IF(AND(K3>25,K3<30),K3,"")

 

[servcoor]

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!

 

[JackDanIce]

You're welcome

 

[maribelbc]

I have values in cell I2, K5 and L5

I need it to have 2 possible returns:
if I2<K5 but >L5=Monthly
if I2>K5 but <L5=Quarterly

Thanks in advance.