Excel中 rand()函数运用请教

AI

A1: = Round(Rand() * 14 + 1) B1: = If(A1:A1 = B1, 37, 1) + Round(Rand() * If(A1 > 1, 18, 19) + 1) C1: = Smaller(COLUMN(C$5:C$26), If(ROW(C$5:C$26) = A1, 37, 1)) + Round(Rand() * (22 - CountIF(A1:A1, ">4")) + 1) D1: = Smaller(IF(ISNUMBER(MATCH(ROW(D$10:D$31), A1:C1, 0)), 37, W(D$10:D31)), If(A1:C1 contAIns ">", countif(A1:C1, ">9") + 1)) E1: = If(ISNUMBER(MATCH(ROW(E$17:E34), B1:D1, 0)), 37, E$17:E34), If(B1:D1 contAIns ">", countif(B1:D1, ">16") + 1)) F1: = If(ISNUMBER(MATCH(ROW(F$24:F36), C1:E1, 0)), 37, F$24:F36), If(C1:E1 contAIns ">", countif(C1:E1, ">23") + 1)) G1: = If(ISNUMBER(MATCH(ROW(A$1:A36), F1:F36, 0)), 37, A$1:A36), If(F1:F36 contAIns ">", countif(F1:F36, ">23") + 1))