ExcelBanter - excel formula for a reference between two numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel formula for a reference between two numbers (https://www.excelbanter.com/excel-worksheet-functions/210835-excel-formula-reference-between-two-numbers.html)

excel formula for a reference between two numbers

I am trying to set up a formula for a cell (b2) that references another cell
(A1).
If cell A1 is 200 but <300, then list A1; if not, then leave blank. Can
anyone help me? Thanks!

Mike

excel formula for a reference between two numbers

=IF(AND(A1200,A1<300),A1,"")

"mk" wrote:

I am trying to set up a formula for a cell (b2) that references another cell
(A1).
If cell A1 is 200 but <300, then list A1; if not, then leave blank. Can
anyone help me? Thanks!

excel formula for a reference between two numbers

you're awesome! thanks!
mk

"Mike" wrote:

=IF(AND(A1200,A1<300),A1,"")

"mk" wrote:

I am trying to set up a formula for a cell (b2) that references another cell
(A1).
If cell A1 is 200 but <300, then list A1; if not, then leave blank. Can
anyone help me? Thanks!

All times are GMT +1. The time now is 09:19 PM.