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 December 27, 2022 - Nov 25, 2019 at 12:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 25, 2019 at 12:01 PM
Related:
- How to hide text in excel
- How to hide app store on ipad - Guide
- Number to words in excel - Guide
- How to see hide story on instagram - Guide
- How to take screenshot in excel - Guide
- How to change date format in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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