å¨C1ä¸è¾å
¥æå¤å¶ç²è´´æ¤å
¬å¼
ä»B1ä¸éæºå åAåä¸å 个åå
æ ¼ä¸çä»»ä¸æ°å¼
=B1+INDIRECT("A"&RANDBETWEEN(1,100))*(-1)^RANDBETWEEN(1,2)
ä»B1ä¸éæºå åAåä¸å 个åå
æ ¼ä¸çå¼çå
=B1+SUM(INDIRECT("A"&RANDBETWEEN(1,100)&":A"&RANDBETWEEN(1,100)))*(-1)
^RANDBETWEEN(1,2)
温馨提示:答案为网友推荐,仅供参考