Compare 2 values and Return Smallest Value

[rskip]

So I have used the formula:
=MIN (AN1734:AO1734)
And this works fine
However if AN1734 or AO1734 have no data, it returns 0:00.000 (Cell is formatted for m:ss.000)
I would like it to return DNCL
I tried to use
=IFERROR(MIN(AN1735:AO1735),"DNCL")
However it just returns 0:00.000

Thanks you guys are life savers !!
Cheers

 

[dreid1011]

How about this:

=IF(MIN(AN1734:AO1734),MIN(AN1734:AO1734),"DNCL")

IFERROR didn't work because 0 is not an error value.

 

[JMWh1t3]

=IF(A3="","DNCL",IF(B3="","DNCL",IF(A3>B3,B3,A3)))

Just replace A3:B3 with your 2 cells.

 

[rskip]

Cheers Guys, Thanks