REMOVING " FALSE " VALUE IN "IF&quo

Closed
dieselkhan Posts 1 Registration date Sunday 7 September 2014 Status Member Last seen 7 September 2014 - 7 Sep 2014 à 16:55
 RayH - 9 Sep 2014 à 20:45
Hello,
I would like to know how to remove the "False" Value when if function is nested.
Here is an Example
=IF(C13="",IF((K13>="06:00"+0)*(K13<="23:59"+0),"Yes","NO"))

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(C13="",IF((K13>="06:00"+0)*(K13<="23:59"+0),"Yes","NO")),"")
But still i am getting the same False Value in default
Expert advice is much appreciated on this
Thank you
Waiting


1 response

=IF(C13="",IF((K13>="06:00"+0)*(K13<="23:59"+0),"Yes","NO"),"")

You need to add the additional FALSE clause to handle this.