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!
Bookmarks