xls输入落入low_limit,up_limit区间数值,返回对应prob_range数值,注意区间“100%-200%”,公式要精简.low_limitup_limitprob_range0%70%0%70%75%60%75%80%65%80%85%70%85%90%75%90%95%80%95%100%90%100%120%(X-100%)*5+100%1

xls输入落入low_limit,up_limit区间数值,返回对应prob_range数值,注意区间“100%-200%”,公式要精简.low_limitup_limitprob_range0%70%0%70%75%60%75%80%65%80%85%70%85%90%75%90%95%80%95%100%90%100%120%(X-100%)*5+100%1
xls输入落入low_limit,up_limit区间数值,返回对应prob_range数值,注意区间“100%-200%”,公式要精简.
low_limitup_limitprob_range
0%70%0%
70%75%60%
75%80%65%
80%85%70%
85%90%75%
90%95%80%
95%100%90%
100%120%(X-100%)*5+100%
120%+∞200%

xls输入落入low_limit,up_limit区间数值,返回对应prob_range数值,注意区间“100%-200%”,公式要精简.low_limitup_limitprob_range0%70%0%70%75%60%75%80%65%80%85%70%85%90%75%90%95%80%95%100%90%100%120%(X-100%)*5+100%1
此函数不存在!