这可以使用MEDIAN来完成.MEDIAN选择三个值的中间值，从而有效地限制了上下限.

This can be done using MEDIAN. MEDIAN picks the middle of the three values, thus effectively restricting the lower and upper limits.

例如，假设您的下限为5，最大为10:

For example say your minimum is 5 and your maximum is 10:

= MEDIAN(5,0,10)是5

= MEDIAN(5,7,10)是7

= MEDIAN(5,12,10)是10