remove zero from min formula
 

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,AM 3,0)),(IF(BI3=0,BA3,0)),(IF(BW3=0,BO3,0)),(IF(CK3= 0,CC3,0)))

remove zero from min formula
 

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(CR0 [which would only examine positive non-zero values]

At least I think that's what you want.

"Frenz" wrote:

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,AM 3,0)),(IF(BI3=0,BA3,0)),(IF(BW3=0,BO3,0)),(IF(CK3= 0,CC3,0)))