Checking if a cell has absolutely nothing in it
I have a sheet where I have needed to suppress any errors with ISERROR function. The formulas are showing blank now because division by zero errors are suppressed. The formulas will show data when data is entered in other cells. The issue is when someone adds a row to the sheet, I want to make it apparent that they forgot to copy these formulas into the new row by doing a check.
I created a column called "VALID ROW ?" with this formula =IF(OR(ISBLANK([VALUE / HOUR]7) = 1, ISBLANK([PICK NEXT]7 = 1)), "No", "Yes"), but that won't work because it's checking if the cells are blank, not empty. Is there a function that checks if a cell is completely empty, including not only blanks, but formulas that are returning blanks?