I have a '0' that need's to be gone Solved/Closed

Question

Hello, 
I have a file with two sheets.
In sheet2 I have cell A1 ='sheet1'!A1 (when I type something in cell A1 from sheet1 it's goes on A1 from sheet2)
My problem is that on A1 from sheet2 I have a "0" if nothing is inputed in A1 from sheet1... I want a 'blank space'.... can it be done with out complicating to much the file?

Tnx



System Configuration: Android / SamsungBrowser 14.2

vcoolio · Answer

Hello P4f,

Not unlike Mazzaropi's reply in your last thread, just changing the formula to an IF statement should work for you:-

=IF(Sheet1!A1="","",Sheet1!A1)

I hope that this helps.

Cheerio,
vcoolio.

vcoolio · Answer

You're welcome P4f. I'm glad to have been able to assist.

Cheerio,
vcoolio.

I have a '0' that need's to be gone

2 responses

Similar discussions

Subscribe To Our Newsletter!