Need help to remove FALSE from cell

[Solved/Closed]
Report
Posts
1
Registration date
Saturday August 18, 2012
Status
Member
Last seen
August 19, 2012
-
 TLP -
Hello,

Anyone please. How remove FALSE from a cell

Here below is my formula.
=IF(ISNUMBER(G17);IF((G17-$I$10)<=0;0;G17-$I$10))

I have tried to insert ;" " at the end of the formula but it don't work.

I'm just a user, not an expert. Make it simple for me to understand.
Thank you in advance for any help and support
TLP


Related:

4 replies

Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
Hi Ilgatto,

Use this:
=if(iserror(IF(ISNUMBER(G17);IF((G17-$I$10)<=0;0;G17-$I$10))),"",IF(ISNUMBER(G17);IF((G17-$I$10)<=0;0;G17-$I$10)))

Whenever an error occurs, nothing is displayed.

Best regards,
Trowa
Hello Trowa,

Thank you for your time. Unfortunately the FALSE still appears on the cell. I not too sure what else I can do. Do you have any other advises?
Thank you for your support.
TLP
=IF(ISNUMBER(G17),IF((G17-$I$10)<=0,0,G17-$I$10),"")

The ISNUMBER needs a value if the result is false
It si working well now,
Thank you for your help
TLP

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!