Trying to achieve the goal below, and it partially works, however, when cell A2 is empty, then I'm getting 0% (preferably I would like to get no input). Any idea how to divide the formula?

The formula I'm currently using that works but not perfectly: =IF(AND(A2<>"",B2="",C2="",D2="",E2="",F2=""),"100%","0%")

Goal:

1. If cells from B2 to F2 are empty, then 100%
2. If one of the cells is not empty, then 0%
3. If cell A is empty, then "" (the cell should be empty without any % symbol)

CodePudding user response：

It should work by adding another check. If one of the cells within B2:F2 are not empty, then it checks if A2 is empty. If it is, it returns a blank value. If it is not, it returns 0%.

=IF(ISBLANK(A2), "", if(AND(B2="",C2="",D2="",E2="",F2=""),"100%", "0%"))

CodePudding user response：

try:

=IF(A2="",,IF((B2="")*(C2="")*(D2="")*(E2="")*(F2=""), "100%", "0%"))