This array formula will not take 0 into consideration while calculating the min in excel. If there are zero’s in our range in which we want to find minimum value, 0 will be returned.īelow is the data in which we want to find the minimum value in range A1:E1 and as you could see we have 0 in the range and by applying a simple Min formula to find the minimum will give us 0, so to avoid that we would use an array formula with a combination of Min and IF to prevent excel from returning 0 as the min result.Įnter the formula =MIN(IF(A1:E1>0,A1:E1)) in cell B3 and press Ctrl & Shift while pushing ENTER as it is an array formula. Let’s see in this post how we could exclude 0 in calculating minimum in excel.īy default as you know the MIN formula in excel will take 0 as minimum (if negative values are not there), and we want the MIN formula to return non 0 minimum value in excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |