![]() |
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") |
All times are GMT +1. The time now is 01:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com