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")
|