"IF" Statement to check if value is NULL

[sourbeer]

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!

[rvasquez]

Try this

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

Thanks!

RVASQUEZ

[Cutter]

If K4:N4 are numeric values:

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

[sourbeer]

There it is! I knew it was something little I was missing. I forgot that a mathematical equation cannot return a NULL. Thanks for your help!