Removing " false" value in "IF"

JIN - Updated on Dec 10, 2018 at 12:56 PM
 share - Jun 19, 2017 at 05:09 AM

I would like to know how to remove the "False" Value when if function is nested.

Here is an Example


Now When I select the value link to this Function I get the desired result as I wanted , but now I dont want the

False Value to be shown d if the given criteria in the cell is not Met

I tried this also


But still I am getting the same False Value in default

Expert advice is much appreciated on this

Thank you

System Configuration: Windows XP
Internet Explorer 8.0

5 responses

bhawkins Posts 5 Registration date Saturday April 4, 2009 Status Member Last seen April 6, 2009 10
Apr 5, 2009 at 07:35 AM
Okay, well excep that u have to have semicolons(;) instead of commas (,) in the function it worked pretty fine for me with some corrections. Like this...

this is what u have

where it should be

notice the semicolon on the end, if voided u will have an error because u dont have false state
this function will result with a ZERO (0) if false
you can also do this
this will result with a blank cell if false

i hope it helped
Thank you!
Thanks - just what I was looking for.