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:

column B	column C	Column D
00:00-18:00	09:15 - 17:00	=IFERROR(IF(AND(--LEFT(C69,5)>=--LEFT(B69,5),--RIGHT(C69,5)<=--RIGHT(B69,5)),"","WRONG"),"")

<tbody> </tbody>

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