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
2638
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 4, 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
2638
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 4, 2020
 432
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
Comment
Thank you
1
Thank you

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

CCM 3154 users have said thank you to us this month

Reply Ask a question