Greater Than/Less Than Question (IF statement?)
 

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?

Greater Than/Less Than Question (IF statement?)
 

Look in the help index for AND and then IF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill" wrote in message
...
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?

Greater Than/Less Than Question (IF statement?)
 

Bill,

Try

=AND(A1B1,A1<C1)

Mike

"Bill" wrote:

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?