Referencing Cells | Excel 2010

[John Jahn]

Sheet "Parts List" & "Quote"

Parts List Cell B5 = type info
Quote Cell B5 = what Parts List has in B5

Formula in Quote B5 { ='Parts List'!B5 }

Q) when no content is in Parts List B5, Quote B5 shows "0", is there a way to show nothing until Parts List B5 has something in it?

 

[VoG]

Try

=IF('Parts List'!B5="","",'Parts List'!B5)

 

[John Jahn]

Thanks, worked. I was trying " "