Remove False from cell

Solved/Closed
Ilgatto - 16 Aug 2012 à 22:43
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Aug 2012 à 10:31
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

Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
20 Aug 2012 à 10:31
Hi Ilgatto,

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

Whenever an error occurs, nothing is displayed.

Best regards,
Trowa