Formula showing 0 - don't want it displayed
I'm using the following formula to bring data over from one tab to another,
however, if there is nothing in cell B4 on the Status tab its returning a 0
in the cell. I don't want to see anything in the cell. What do I have to do
to modify this? Thanks in advance.
=IF($B4=Status!$B4,Status!C4,"")
I tried this formula, but it also didn't work - still displays 0
=IF(ISERR(IF($B4=Status!$B4,Status!C4,"")),"",IF($ B4=Status!$B4,Status!C4,""))
|