Menu

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
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 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
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 2020
 390
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 5417 users have said thank you to us this month

Reply Ask a question