Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
 -
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 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
See more

1 reply

Answer 1 / 1
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
 446
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
Reply Ask a question