How to hide text in a Excel cell and display it when needed
Solved/Closed
john_thomas
Posts
1
Registration date
Sunday November 24, 2019
Status
Member
Last seen
November 24, 2019
-
Nov 24, 2019 at 04:34 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 25, 2019 at 12:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 25, 2019 at 12:01 PM
Related:
- How to hide text in a Excel cell and display it when needed
- How to know if someone hide their story from you on instagram - Guide
- How to hide app store on ipad - Guide
- How to take screenshot in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel without vba - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Nov 25, 2019 at 12:01 PM
Nov 25, 2019 at 12:01 PM
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