出了点小问题,就是按F9刷新后出现 “无效的单元格引用”答:S10=INDEX({354,418,429,376,421,428,456,435,428,423},1,1+MATCH(R10,{354,418,429,376,421,428,456,435,428,423})+INT(RAND()*(10-MATCH(R10,{354,418,429,376,421,428,456,435,428,423})))把公式中的(10-...)改为(9-...S10=INDEX({354,418,429,376,421,428,456,435...