system
1
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)
system
2
Right click on the cell, choose Format Cell…, choose Number format, under “undefined” enter “0”.
Andreas
(BOB member since 2002-06-20)
system
3
Uh, duh. Thank you!
Lisa
lisachoi (BOB member since 2004-06-24)
system
4
You can also use the IsNull function…
Christian Konrads
(BOB member since 2004-07-21)