ExcelBanter - test if a value is in a range of values

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - test if a value is in a range of values (https://www.excelbanter.com/excel-programming/409278-test-if-value-range-values.html)

jfrick

test if a value is in a range of values

I am trying to write a formula that tests a cell value to see if it matches
values in a range of values and returns either true or false. Any help
would be greatly appreciated.

Josh

joel

test if a value is in a range of values

=IF(AND(A1=5,A1<=10),TRUE,FALSE)

"jfrick" wrote:

I am trying to write a formula that tests a cell value to see if it matches
values in a range of values and returns either true or false. Any help
would be greatly appreciated.

Josh

All times are GMT +1. The time now is 06:17 AM.