title: Identifying a blank cell in Excel Office 365 using the function =IF(ISBLANK)
body: <p>Using excel office 365 for Mac I have entered, in cell A11, the function =if(ISBLANK(B12),0,IF(B12=0,0,B12)) to determine whether cell B12 is blank and, if so, enter 0 in cell A11, otherwise enter the content of cell B12.  Works OK except if cell b12 is emptied using the space key, in which case the result cannot be used in another cell.  Any thoughts on how to recognize a 'space bar' clearance as BLANK would be appreciated. This situation is not dealt with in the various searches I have tried and Microsoft Support has been of no help at all. </p>