REMOVING " FALSE " VALUE IN "IF&quo

Closed
dieselkhan Posts 1 Registration date Sunday September 7, 2014 Status Member Last seen September 7, 2014 - Sep 7, 2014 at 04:55 PM
 RayH - Sep 9, 2014 at 08:45 PM
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.
0