What is the most effective formula to meet those conditions:
-
If the cell value is greater than 1, than return me 0
-
If the cell value is equal to 1, return me 1
-
If the cell is blank (even though it has some formula inside), return me a blank cell
-
If the cell value is equal to 0, return me a blank cell
Thank you!!
>Solution :
Use OR and nest IF:
=IF(OR(A1={"",0}),"",IF(A1=1,1,0))
