Greater Than/Less Than Question (IF statement?)

[Bill]

how do you create a function that returns a result (i.e. true/false) if cell
A is greater than cell B, but less than cell C?

 

[Don Guillett]

Look in the help index for AND and then IF

 

[Mike H]

Bill,

Try

=AND(A1>B1,A1<C1)

Mike