结构:
只有两个字段
文本格式:数量
数字格式:计算
其中计算的默认值为函数计算
目的:
若“数量”字段包含“-”符号,则调用 FIND 取上下限,RANDBETWEEN 取其中间随机值;否则直接返回
过程:
IF(INCLUDE(数量,"-"),RANDBETWEEN(1,2),数量)——正常
IF(INCLUDE(数量,"-"),RANDBETWEEN(FIND(数量,"","-"),10),数量)——无-正常,有-正常
IF(INCLUDE(数量,"-"),RANDBETWEEN(10,FIND(数量,"-","")),数量)——无-正常,有-错误
IF(INCLUDE(数量,"-"),RANDBETWEEN(FIND(数量,"","-"),FIND(数量,"-","")),数量)——无-正常,有-错误
私有部署,版本 6.5.3