Solved Excel - Minimum value from cell range but except zero value

July 7, 2013 at 23:59:27
Specs: Windows XP, 4096
Hello everyone,

Making an Excel template for the calculation of effective production capacity on 5 tools I've put the =MIN(X1;X5) formula to find the bottleneck capacity on those 5 processes in order to use this lowest capacity as a final process capacity.
But it is possible that some processes are not in use in some configuration so that some of the cells X1;X5 may have value 0.
My question is if I could skip somehow such a cell in the condition MIN(X1;X5) so that only positive (bigger than zero) values are considered?

Thank you all in advance for any support!

Zennon


See More: Excel - Minimum value from cell range but except zero value

Report •

#1
July 8, 2013 at 06:49:14
✔ Best Answer

Report •

#2
July 8, 2013 at 22:21:54
Mmcconaghy, thanks a lot!
:-)

Zennon


Report •
Related Solutions


Ask Question