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


4 replies

Posts
2646
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 1, 2020
432
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