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

Solved
Report
-
Posts
1326
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 28, 2021
-
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

2 replies

Posts
1326
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 28, 2021
241
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.
Work's great!!!!
Thank you so much!!!
Posts
1326
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 28, 2021
241
You're welcome P4f. I'm glad to have been able to assist.

Cheerio,
vcoolio.