Output a NULL cell value in Excel
- by Peter
I have an IF statement. If a cell = n, then do something, else output NULL
=IF(A1=5, "Success", NULL) // #NAME?
=IF(A1=5, "Success", "NULL") // NULL (as in text, not actually NULL!)
=IF(A1=5, "Success", "") // blank but not NULL
=IF(A1=5, "Success", 0) // zero value but not NULL