How to hide text in a Excel cell and display it when needed
Solved/Closed
john_thomas
Posts
1
Registration date
Sunday 24 November 2019
Status
Member
Last seen
24 November 2019
-
24 Nov 2019 à 16:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Nov 2019 à 12:01
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Nov 2019 à 12:01
Related:
- How to hide text in excel
- Excel hide text - Best answers
- Hidden text in excel - Best answers
- How to hide steam comments - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to change date format in excel - Guide
- How to hide videos on youtube - Guide
- Arrow keys not working in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
25 Nov 2019 à 12:01
25 Nov 2019 à 12:01
Hi John,
To do that, you will need to put in another IF statement:
=IF([@[Total Fee]]="","",IF([@[Total Fee]]-[@[Total Paid]]>=0,""Pending","Completed")
Best regards,
Trowa
To do that, you will need to put in another IF statement:
=IF([@[Total Fee]]="","",IF([@[Total Fee]]-[@[Total Paid]]>=0,""Pending","Completed")
Best regards,
Trowa
