In Excel, I need to return a value of 1 if a referenced cell is empty. I can do it if ... You can use: =IF(ISBLANK(A1),1,0). but you should be careful what you mean by ...
stackoverflow.com