If a cell is blank
|
Cell Reference
|
|
Value if blank
hint: if entering a text value then need to enclose it in double quotation marks (e.g. "value") |
|
Value if not blank
hint: if entering a text value then need to enclose it in double quotation marks (e.g. "value") |
|
Formula
|
=IF(C5="",J1,J2)
=IF(C5="",J1,J2)