ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula for Colin F (https://www.excelbanter.com/excel-worksheet-functions/32170-formula-colin-f.html)

Barb R.

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