How to show an empty cell if =COUNTA counts 0?
Closed
101lols
-
Updated by 101lols on 6/02/17 at 06:55 PM
TrowaD
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- How to show an empty cell if =COUNTA counts 0?
- Can the formula COUNTA / COUNT exclude 0 values? ✓ - Forum - Excel
- This formula is used to count the value in one or more cells (this will count the cells irrespective of number or text value). ✓ - Forum - Office Software
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
- Macro copy and paste in next blank cell - Guide
1 reply
TrowaD
Feb 7, 2017 at 11:24 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
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