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

Question

Previous Topic Next Topic

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

Report

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: 2776
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 26, 2021

- 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 remove apostrophe in excel cell - How-To - Excel
How to insert picture in excel cell automatically from folder - Forum - Excel
Hide formula bar in excel - How-To - Excel
Screenshot excel cells - How-To - Excel
Edit excel cell without double clicking ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Accepted Answer · 2019-11-25T12:01:13-0500

Answer 1 / 1

TrowaD

Posts: 2776
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 26, 2021

465
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

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

1 reply

Your reply

Subscribe To Our Newsletter!