excel is null - ailee is you
$800.00
To test if a cell is not blank (i. kaguya sama love is war final e. kaguya sama love is war final has content), you can use a formula based on the IF function In the example shown, the formula in cell E5 is: =IF(D5"","Done","") As the formula is copied down it returns "Done" when a cell in column D is not blank and an empty string ("") if the cell is blank