I have a '0' that need's to be gone
Solved/Closed
Pupic4fun
-
Jul 20, 2021 at 08:11 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jul 21, 2021 at 07:58 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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
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:
- 192ز168ز0ز1
- //192.168.l.0 - Guide
- Xbox-2309-1001-3-0 - Download - Digital stores
- Whatsapp-desktop-2-2401-5-0.msixbundle - Download - Instant messaging
- Fsutil behavior set disableencryption 0 - Guide
- Summertimesaga-0-20-16-pc - Download - Adult games
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jul 21, 2021 at 02:52 AM
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.
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
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jul 21, 2021 at 07:58 PM
Jul 21, 2021 at 07:58 PM
You're welcome P4f. I'm glad to have been able to assist.
Cheerio,
vcoolio.
Cheerio,
vcoolio.
Jul 21, 2021 at 09:43 AM
Thank you so much!!!