Removing " false" value in "IF"

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

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

Here is an Example

=IF(C11="Evening",200,IF(C11="Gazetted",1000,IF(C11="Night",200)))

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

=IFERROR(IF(C9="Evening",200,IF(C9="Gazetted",1000,IF(C9="Night",200))),"")

But still I am getting the same False Value in default

Expert advice is much appreciated on this

Thank you

Waiting
System Configuration: Windows XP
Internet Explorer 8.0

5 replies

bhawkins Posts 5 Registration date Saturday April 4, 2009 Status Member Last seen April 6, 2009 9
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
=IF(C11="Evening",200,IF(C11="Gazetted",1000,IF(C11="Night",200)))

where it should be
=IF(C11="Evening";200;IF(C11="Gazetted";1000;IF(C11="Night";200;)))

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
=IF(C11="Evening";200;IF(C11="Gazetted";1000;IF(C11="Night";200;"")))
this will result with a blank cell if false

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