I have a text list dropbox with one blank cell included in cell A1. In B1 I have a formula that says =IF(A1<>0,1+1,""). No matter if the blank or text is chosen B1 shows as "2".
I have also tried with ISBLANK and ISTEXT but get the same results. I should be getting a blank cell in B1 to work correctly.
Please advise, thank you.
I have also tried with ISBLANK and ISTEXT but get the same results. I should be getting a blank cell in B1 to work correctly.
Please advise, thank you.