Need help to remove FALSE from cell Solved/Closed

Question

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


Configuration: Windows 7 / Internet Explorer 9.0

TrowaD · Answer

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

TLP · Answer

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

RayH · Answer

=IF(ISNUMBER(G17),IF((G17-$I$10)<=0,0,G17-$I$10),"")

The ISNUMBER needs a value if the result is false

TLP · Answer

It si working well now,
Thank you for your help
TLP

Need help to remove FALSE from cell

4 responses

Similar discussions

Subscribe To Our Newsletter!