Found to find Max or Min when includes negative #s

[trillium]

Hi

I have a range that spans from -100% to +100%. I need to identify if any values in that range exceeds -50% or +50%. I've tried to use an array with ABS and MATCH but the convert the -50% to +50%. Is there a way around this?

example:
-77% -35% 0% +48%

answer is -77%

Thanks!

[Domski]

Maybe: =IF(ABS(MIN(A1:A4))>0.5,MIN(A1:A4),IF(MAX(A1:A4)>0.5,MAX(A1:A4),""))

Dom

[trillium]

thanks!!!!