这个公式错误在哪里?

这个公式错误在哪里？怎么简化？？ =IFERROR(IFS(OR(D8="AA",D8="ZAA"),IFS(H8<=241,680,H8<=269,640,H8<=285,600,H8<=302,580,H8<=325,560,H8<=341,540,H8<=365,500),D8="BB",IFS(H8<=241,700,H8<=269,660,H8<=285,640,H8<=302,620,H8<=325,600,H8<=345,560,H8<=365,540),OR(D8="CC",D8="CCA",D8="CVA",D8="CCVA"),IFS(H8<=241,700,H8<=269,680,H8<=285,660,H8<=302,640,H8<=329,620,H8<=345,600,H8<=365,580),OR(D8="D30",D8="41D"),IFS(H8<=241,680,H8<=269,660,H8<=285,640,H8<=302,600,H8<=329,580,H8<=345,540,H8<=365,500),OR(D8="EE",D8="E5"),IFS(H8<=241,620,H8<=269,600,H8<=285,560,H8<=302,520,H8<=325,500,H8<=345,480,H8<=365,460)),"")

WPS表格

20小时前四川省

1 +1

草莓可乐酱汁

IFERROR(LET(a,{241,269,285,302,325,341,365},b,{680,640,600,580,560,540,500},c,{700,660,640,620,600,560,540},d,{700,680,660,640,620,600,580},e,{680,660,640,600,580,540,500},f,{620,600,560,520,500,480,460},XLOOKUP(H8,a,IF(OR(D8="AA",D8="ZAA"),b,IF(D8="BB",c,IF(OR(D8="CC",D8="CCA",D8="CVA",D8="CCVA"),d,IF(OR(D8="D30",D8="41D"),e,IF(OR(D8="EE",D8="E5"),f))))),"",1)),"")可以试一下

4小时前 · 湖北省

LZN

看着象是根据条件判断值，可以建一个辅助的表格。用Vlookup函数取值。这个太长了，看着眼晕

4小时前 · 山东省

千叶

=LET(A,{241;269;285;302;325;329;341;345;365},B,{680,700,700,680,620;640,660,680,660,600;600,640,660,640,560;580,620,640,600,520;560,600,620,580,500;540,560,620,580,480;540,560,600,540,480;500,560,600,540,480;500,540,580,500,460},C,{0,0;"AA",1;"ZAA",1;"BB",2;"CC",3;"CCA",3;"CVA",3;"CCVA",3;"D30",4;"41D",4;"EE",5;"E5",5},IFERROR(XLOOKUP(H8,A,INDEX(B,,VLOOKUP(D8,C,2,0)),,1),"")) 有两个数不知道是不是你写错了 329和341 我标黄的你看看

8小时前 · 江西省