In Excel, I need to return a value of 1 if a referenced cell is empty. I can do it if ... P4 is the cell I test for: =IF(ISBLANK(P4),1,0) ...
stackoverflow.com