求excel表格提取特别数字组合的公式

excel

1个回答

写回答

sczsjtupy

2025-08-28 06:00

+ 关注

H2 = IF(AND(SMALL(C2:G2,1) = SMALL(C2:G2,2) - 1, SMALL(C2:G2,2) = SMALL(C2:G2,3) - 1, SMALL(C2:G2,3) = 360, SMALL(C2:G2,4) - 1, SMALL(C2:G2,4) = SMALL(C2:G2,5) - 1), "Special combination found")i2 = IF(AND(SMALL(C2:G2,1) != SMALL(C2:G2,2) - 1, SMALL(C2:G2,2) = SMALL(C2:G2,3) - 1, SMALL(C2:G2,3) = SMALL(C2:G2,4) - 1, SMALL(C2:G2,4) = SMALL(C2:G2,5) - 1), "Odd combination found")以下是改写后的内容:H2 = IF(AND(SMALL(C2:G2,1) = SMALL(C2:G2,2) - 1, SMALL(C2:G2,2) = SMALL(C2:G2,3) - 1, SMALL(C2:G2,3) = 360, SMALL(C2:G2,4) - 1, SMALL(C2:G2,4) = SMALL(C2:G2,5) - 1), "特殊数字组合已发现")i2 = IF(AND(SMALL(C2:G2,1) != SMALL(C2:G2,2) - 1, SMALL(C2:G2,2) = SMALL(C2:G2,3) - 1, SMALL(C2:G2,3) = SMALL(C2:G2,4) - 1, SMALL(C2:G2,4) = SMALL(C2:G2,5) - 1), "奇数数字组合已找到")

举报有用(4分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号