I have a '0' that need's to be gone [Solved]

Report
-
Posts
1308
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 22, 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
1308
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 22, 2021
232
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
1308
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 22, 2021
232
You're welcome P4f. I'm glad to have been able to assist.

Cheerio,
vcoolio.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!