if+and

[kelvin_9]

hello all, i need hand on a IF+AND formula, how can i amend it with my request?

=IFERROR(IF(AND(--LEFT(C59,5)>=--LEFT(B59,5),--RIGHT(C59,5)<=--RIGHT(B59,5)),"","WRONG"),"")

is it possible to return one more request with "NO GIVEN" when it encountered "#N/A"

thanks,
have a great day

 

[MARK858]

Encountered "#N/A" in which cell B59 or C59 (I am assuming B59)? what version of Excel are you using?

 

[kelvin_9]

Encountered "#N/A" in which cell B59 or C59 (I am assuming B59)? what version of Excel are you using?

i apologize for the confuse, MARK858
i use it to return my result like this:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]column B[/TD]
[TD]column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]00:00-18:00[/TD]
[TD]09:15 - 17:00[/TD]
[TD]

=IFERROR(IF(AND(--LEFT(C69,5)>=--LEFT(B69,5),--RIGHT(C69,5)<=--RIGHT(B69,5)),"","WRONG"),"")

[/TD]
[/TR]
</tbody>[/TABLE]

sometimes #N/A will return in column C, so i want column D with my answer - "NO GIVEN" when it is encountered
PS: excel 2013

thanks MARK

 

[MARK858]

...

=IF(ISNA(C59),"NO GIVEN",IFERROR(IF(AND(--LEFT(C59,5)>=--LEFT(B59,5),--RIGHT(C59,5)<=--RIGHT(B59,5)),"","WRONG"),""))

 

[kelvin_9]

...

works prefect, thanks MARK858