K
KC
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,""))
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,""))