Remove False from cell

Solved/Closed
Ilgatto - Aug 16, 2012 at 10:43 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0