I currently am checking 4 cells to see if they are all NULL. If they are NULL then the equation should return a specified value. If the cells return a numeric value, the cell should display NULL.

Here is my statement:

=IF(SUM(K4:N4)="",B4,"")

Example:
B4 is a City
K4:N4 is the cell range I am looking to see if it has a value.

Thanks in advance!