Need help to remove FALSE from cell

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


4 replies

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen October 4, 2022 523
Aug 20, 2012 at 10:35 AM
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