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
Hi friends

I have doubt in excel.
I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on the result received when two other columns (Total Fees $ Total Paid) gets added.
I have added the formula and applied to the entire column. The formula works.
But the text 'Pending' is showing in all the below cells even when there is no data in other cells.
I only want the text to be shown when something is entered in 'Total Fees' column.
Please tell me how to do that.

Thanks

John Thomas
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
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