Previous Topic Next Topic

Remove False from cell

Solved/Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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

Answer 1 / 1
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 490
Hi Ilgatto,

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

Whenever an error occurs, nothing is displayed.

Best regards,
Trowa
Ask a question