Return Empty Cell/Blank

[Zach]

I am looking for a way to return an empty cell when the conditions of a
formula are false.

=IF(A1>0,(A1+9))

This formula is in a given cell, say B1. If A1 is empty I want B1 to stay
empty also. I do not want to return #NA or FALSE. Is there a way this may be
accomplished??

Thanks,

Zach

 

[Guest]

=IF(A1>0,(A1+9),"")

 

[Juan Sanchez]

Zach... 0 lenght string ---> ""

=If(This is True,Value if True, "")

Cheers
Juan

 

[Bob Phillips]

=IF(LEN(A1)=0,"",A1+9)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Zach]

Thanks for the assistance. Always a way to do things in Excel!