Remove False from cell [Solved/Closed]

Question

Remove False from cell [Solved/Closed]

Report

Ilgatto - Aug 16, 2012 at 10:43 PM
TrowaD

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

- Aug 20, 2012 at 10:31 AM

Hello,
how can I remove FALSE from the cell? I need help, any one please.
her below is my formulat
=IF(ISNUMBER(G17);IF((G17-$I$10)<=0;0;G17-$I$10))
What should I do?
thank you in advance for you time and support

Remove False from cell
Need help to remove FALSE from cell ✓ - Forum - Office Software
How to remove false in excel ✓ - Forum - Office Software
Removing False Value ✓ - Forum - Excel
Excel remove formatting from cells - How-To - Excel
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2012-08-20T10:31:52-0400

Answer 1 / 1

TrowaD

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

466
Aug 20, 2012 at 10:31 AM

Hi Ilgatto,

Use this structure:
=if(iserror(YourFormula),"",YourFormula)

Whenever an error occurs, nothing is displayed.

Best regards,
Trowa

Remove False from cell [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!