View Single Post
  #1   Report Post  
Barb R.
 
Posts: n/a
Default Formula for Colin F

As I'm unable to reply to the original message, I'm putting it here.

Q: If (cell a2 is greater than 1, but less than B2 - C2, "X") how do in

Colin, in the future, please put the text of your question in the message
box.

Try the following formula:

=IF(AND(A21,A2<(B2-C2)),"TRUE","FALSE")