Previous Topic Next Topic

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

Solved/Closed
Pupic4fun - Jul 20, 2021 at 08:11 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jul 21, 2021 at 07:58 PM
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
Related:

2 responses

Answer 1 / 2
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jul 21, 2021 at 02:52 AM
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.
0
Pupic4fun
Jul 21, 2021 at 09:43 AM
Work's great!!!!
Thank you so much!!!
0
Answer 2 / 2
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jul 21, 2021 at 07:58 PM
You're welcome P4f. I'm glad to have been able to assist.

Cheerio,
vcoolio.
0

Similar discussions

,">"&0),"") at the end of a countif formula
jutulu -
toony -

4 responses
Toshiba Factory Reset Problem
aliggett63007 -
aliggett63007 -

3 responses
Restoring Toshiba laptop to factory settings
confused -
Kozzo -

43 responses
Toshiba recovery without a CD
Vixen -
Stamatis -

4 responses
Diskette Drive 0 seek failure (error message)
azajewel -
TechIlliterate -

133 responses