Isblank

[visionary]

Thank you for your time first and for most.
I have Sheet 1&2. I want cell A1 in Sheet 2 referencing cell A1 in Sheet 1, whatever appeared in Sheet 1 cell A1 needs to be in cell A1 Sheet 2. This part is done. the next part is when cell A1 Sheet 1 has nothing, right now I want cell A1 in Sheet 2 to display nothing instead of "0". I put in =ISBLANK(Sheet1!A1) and "TRUE" displays in Sheet 2 A1. I need A1 in Sheet 2 just display nothing until I input a value in A1 Sheet 1. How can you help me to resolve this? Thanks.

 

[sheetspread]

=if(isblank(Sheet1!A1),"",Sheet1!A1)

Keep in mind that a cell must be empty to test true with isblank, Go To, etc. "" is still a string.

 

[JoeMo]

or, .. one fewer function calls:

=if(Sheet1!A1="","",Sheet1!A1)

 

[akschary]

or, .. one fewer function calls:

=if(Sheet1!A1="","",Sheet1!A1)

one more formula is
=if(Sheet1!A1>0,Sheet1!A1,"")