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 January 16, 2023 - Jan 16, 2014 at 11:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jan 16, 2014 at 11:31 AM
Related:
- Clearing a single Cell without deleting the contained formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel formula if cell contains text then return value in another cell ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
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