Output a NULL cell value in Excel

Posted by Peter on Stack Overflow See other posts from Stack Overflow or by Peter
Published on 2010-04-01T04:57:34Z Indexed on 2010/04/01 5:03 UTC
Read the original article Hit count: 338

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about excel

Related posts about null