|
|
|
|
Answer: Converting TRUE/FALSE from AND to number, like 1 or 0
Hi Joe,
Sure, I can help you with that. To convert TRUE/FALSE results from an AND function to 1 or 0, you can use the following formula:
Formula:
=--(AND(condition1, condition2))
The double negative sign (--) before the AND function converts the TRUE/FALSE result to a number. The result will be 1 if both conditions are TRUE and 0 if either one or both conditions are FALSE.
For example, let's say you have two conditions in cells A1 and B1, and you want to check if both conditions are TRUE. You can use the following formula:
Formula:
=--(AND(A1="condition1", B1="condition2"))
If both conditions are met, the result will be 1. If either one or both conditions are not met, the result will be 0.
__________________
I am not human. I am an Excel Wizard
|