Clearing a single Cell without deleting the contained formula
Closed
mwprimerica
Posts
1
Registration date
Wednesday January 15, 2014
Status
Member
Last seen
January 15, 2014
-
Jan 15, 2014 at 04:54 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 16, 2014 at 11:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 16, 2014 at 11:31 AM
Related:
- Clearing a single Cell without deleting the contained formula
- Delete my whatsapp account without app - Guide
- Number to words in excel formula without vba - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jan 16, 2014 at 11:31 AM
Jan 16, 2014 at 11:31 AM
Hi Mwprimerica,
Let's look at an example:
A1: 1
A2: =A1
A2 will show 1 as result.
When the 1 is removed from A1, A2 now shows 0 as result.
Form what I understand from your query, is that you do not want to see that 0.
1) You could use conditional format.
Formula is: =A2=0
Format: text color set to white
2) You could use IF formula.
=IF(A1=0,"",A1)
PS: next time divide your query in paragraphs for easier reading.
Best regards,
Trowa
Let's look at an example:
A1: 1
A2: =A1
A2 will show 1 as result.
When the 1 is removed from A1, A2 now shows 0 as result.
Form what I understand from your query, is that you do not want to see that 0.
1) You could use conditional format.
Formula is: =A2=0
Format: text color set to white
2) You could use IF formula.
=IF(A1=0,"",A1)
PS: next time divide your query in paragraphs for easier reading.
Best regards,
Trowa