View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 107
Default 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,""))