Need help to remove FALSE from cell [Solved/Closed]

Posts
1
Registration date
Saturday August 18, 2012
Last seen
August 19, 2012
- - Latest reply:  TLP - Aug 22, 2012 at 01:41 AM
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


See more 

4 replies

Posts
2435
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 4, 2018
0
Thank you
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
0
Thank you
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
0
Thank you
=IF(ISNUMBER(G17),IF((G17-$I$10)<=0,0,G17-$I$10),"")

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