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

Solved/Closed

john_thomas Posts 1 Registration date Sunday November 24, 2019 Status Member Last seen November 24, 2019 - Nov 24, 2019 at 04:34 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 25, 2019 at 12:01 PM

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

How to hide text in a Excel cell and display it when needed
How to hide app store on ipad - Guide
How to know if someone hide their story from you on instagram - Guide
How to take screenshot in excel - Guide
Number to words in excel - Guide
To display a text file in reverse order what command should be used - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 25, 2019 at 12:01 PM

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

Similar discussions

How to use conditional format based on text?

How to calculate positions (1st,2nd,3rd...) in Excel

Highlight cell if another cell contains specific text

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!