Returning row as 0 if count is null

Hi,

How do I return a row as 0 if the count is null?

This is my formula to return count of Notified Employees where the status is “Trans/Cancel/Rehire” but what if there are no count.

=<Notified Emp.> Where (<RIF Status>="Trans/Cancel/Rehire") 

Right now, the row returns blank. I’d like to replace the blank with 0.

Thanks for your help!

Lisa


lisachoi (BOB member since 2004-06-24)

Right click on the cell, choose Format Cell…, choose Number format, under “undefined” enter “0”.


Andreas :de: (BOB member since 2002-06-20)

Uh, duh. Thank you!

Lisa


lisachoi (BOB member since 2004-06-24)

You can also use the IsNull function…


Christian Konrads :it: (BOB member since 2004-07-21)