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

Mmcconaghy, thanks a lot!

:-)Zennon

Ask Your Question

Weekly Poll