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

TLP 1 Posts Saturday August 18, 2012Registration date August 19, 2012 Last seen - Aug 19, 2012 at 12:16 PM - 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

TrowaD 2392 Posts Sunday September 12, 2010Registration dateContributorStatus July 16, 2018 Last seen - Aug 20, 2012 at 10:35 AM
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