How to show an empty cell if =COUNTA counts 0?
Closed
101lols
-
Updated by 101lols on 6/02/17 at 06:55 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 7, 2017 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 7, 2017 at 11:24 AM
Related:
- How to show an empty cell if =COUNTA counts 0?
- //192.168.l.0 - Guide
- Conditional formatting if cell contains text - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- *#0*# huawei - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 7, 2017 at 11:24 AM
Feb 7, 2017 at 11:24 AM
Hi 101lols,
Try using your formula in combination with the IF formula.
=IF(YourFormula=0,"",YourFormula)
Best regards,
Trowa
Try using your formula in combination with the IF formula.
=IF(YourFormula=0,"",YourFormula)
Best regards,
Trowa