Remove False from cell [Solved/Closed]

Report
-
Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
-
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

1 reply

Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
460
Hi Ilgatto,

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

Whenever an error occurs, nothing is displayed.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!