remove zero from min formula

[Frenz]

I've done the below formula but would like to omit zeros. How should i
proceed from here...?
=MIN((IF(S3=0,K3,0)),(IF(AG3=0,Y3,0)),(IF(AU3=0,AM3,0)),(IF(BI3=0,BA3,0)),(IF(BW3=0,BO3,0)),(IF(CK3=0,CC3,0)))

 

[JLatham]

Change all of your IF(CR=0 (wher CR is a column/row cell ID as S3, AG3, etc)
to
IF(CR<>0 [which will account for negative and positive non-zero values] or
IF(CR>0 [which would only examine positive non-zero values]

At least I think that's what you want.