B
Barb R.
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(A2>1,A2<(B2-C2)),"TRUE","FALSE")
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(A2>1,A2<(B2-C2)),"TRUE","FALSE")