If statement with or

[ron0816]

Help, I need a if statement that will return what is in a cell based on a another cell. I need it to know if a cell is less than 2999 but greater than 8999 to return a the value in the cell next to it. If it does not meet the criteria then leave blank. Can someone help me.

 

[gaz_chops]

Welcome to Mr Excel,

Try

=IF(OR(A2<2999,A2>8999),B2,"")

 

[ron0816]

That works like magic. Thanks gaz

 

[gaz_chops]

You're welcome.