How to hide text in a Excel cell and display it when needed [Solved]

Report
Posts
1
Registration date
Sunday November 24, 2019
Status
Member
Last seen
November 24, 2019
-
TrowaD
Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
-
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

1 reply

Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
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
1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 4245 users have said thank you to us this month