"between" comparison operator

matmich · Jun 8, 2004

i have had a mental block -- what is the formula in Excel for "between
operator.

I have a number in A1, so in A2 I need to display a "Y" of this numbe
is greater than 84 or less than or equal to 10

Andy B · Jun 8, 2004

Hi

You could use an AND statement:
=IF(AND(A1>84,A1<=108),"Yes","No")

Guest · Jun 8, 2004

Try

=IF(or(A1>84,A1<=108),"Y","")

Charlie O'Neill

Michael Hopwood · Jun 8, 2004

=IF(or(A1>84,A1<=108),"Y","")

Your OR should be an AND.

Excel Need Countifs Formula Help	0	Apr 24, 2021
if, and, or "or" statement	3	Jun 8, 2004
IF Function	2	May 5, 2008
How do I Make a "IF" formula where it reads between 2 sets of numb	2	May 15, 2008
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate	1	Nov 25, 2014
Convert text to number automatically	1	May 13, 2010
Function Argument Question	4	Apr 26, 2010
return a value between set numbers	3	Dec 31, 2008

"between" comparison operator

matmich

Andy B

Guest

Michael Hopwood

Ask a Question

Similar Threads