What is the most effective formula to meet those conditions:

1. If the cell value is greater than 1, than return me 0

2. If the cell value is equal to 1, return me 1

3. If the cell is blank (even though it has some formula inside), return me a blank cell

4. If the cell value is equal to 0, return me a blank cell

Thank you!!

CodePudding user response：

Use OR and nest IF:

=IF(OR(A1={"",0}),"",IF(A1=1,1,0))