MIN function: The pros and cons
Posted: Sat Mar 24, 2007 4:00 pm
Hi,
When should I use the MIN function?
The function can make equations concise and scholar, but the equations may not be easily understood by all. Alternatively, I can use the IF THEN ELSE function instead. But, the resulting equations get longer.
Which of the below rate-equations should I adopt? Both are equivalent, and intended to control the flow of people that can enter a 1-m-width walkway. There is the walkway capacity that limits the largest number of people entering the area:
1. Flow rate = MIN (potential loading, MAXIMUM LOADING)
or,
2. Flow rate = IF THEN ELSE (potential loading > MAXIMUM LOADING, MAXIMUM LOADING, potential loading)
where potential loading is the number of people who attempt to enter the pathway at any given time (people/min), and MAXIMUM LOADING is the maximum number of people that can enter the pathway (say, 25 people/min). Do you think which equation is better?
Monte
When should I use the MIN function?
The function can make equations concise and scholar, but the equations may not be easily understood by all. Alternatively, I can use the IF THEN ELSE function instead. But, the resulting equations get longer.
Which of the below rate-equations should I adopt? Both are equivalent, and intended to control the flow of people that can enter a 1-m-width walkway. There is the walkway capacity that limits the largest number of people entering the area:
1. Flow rate = MIN (potential loading, MAXIMUM LOADING)
or,
2. Flow rate = IF THEN ELSE (potential loading > MAXIMUM LOADING, MAXIMUM LOADING, potential loading)
where potential loading is the number of people who attempt to enter the pathway at any given time (people/min), and MAXIMUM LOADING is the maximum number of people that can enter the pathway (say, 25 people/min). Do you think which equation is better?
Monte