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

Question

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: 2693
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 18, 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
Hide formula bar in excel - How-To - Excel
How to clear formatting in excel cell - How-To - Excel
Edit excel cell without double clicking ✓ - Forum - Excel
Excel cell flash when date is near - Forum - Excel
Insert picture in excel cell automatically - Forum - Excel

1 reply

Ask a question

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

Answer 1 / 1

TrowaD

Posts: 2693
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 18, 2021

455
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!