I need a formula to know if these (2 Min) are within 5% apart

[j5b9]

I need a formula to know if these (2 Min) are within 5% apart
MIN(BY38:BY63)
MIN(BY54:BY68)

 

[VoG]

Possibly

=IF(ABS(MIN(BY38:BY63)-MIN(BY54:BY68)/MIN(BY38:BY63))< 0.05,"Yes","No")

 

[j5b9]

Possibly

=IF(ABS(MIN(BY38:BY63)-MIN(BY54:BY68)/MIN(BY38:BY63))< 0.05,"Yes","No")

It did not work I have a MIN(BY54:BY68) is -.13 and
MIN(BY38:BY63) is -.11

 

[VoG]

Try

=IF(ABS(MIN(BY38:BY63)-MIN(BY54:BY68))/ABS(MIN(BY38:BY63))< 0.05,"Yes","No")

That should give No.

 

[j5b9]

that is correct Thank you for your help!