怎么在excel中输入公式计算_怎么在excel中输入公式 环球报资讯

互联网   2023-05-19 11:15:26


(相关资料图)

1、第一个:=SUM(COUNTIF(B4:G4,B3),COUNTIF(B4:G4,C3),COUNTIF(B4:G4,D3),COUNTIF(B4:G4,E3),COUNTIF(B4:G4,F3),COUNTIF(B4:G4,G3)),应该可以用COUNTIFS的,但我测试了不行,我再研究一下。

2、第二个:=SUM(IF((C3-B3)=1,1),IF((D3-C3)=1,1,0),IF((E3-D3)=1,1,0),IF((F3-E3)=1,1,0),IF((G3-F3)=1,1,0)),这个要求你的6个数,即B3到G3必须是升序的。

3、第三个:没弄出来第四个:=RIGHT(B3,1)&IF(RIGHT(C3,1)=RIGHT(B3,1),"","、"&RIGHT(C3,1))&IF(OR(RIGHT(D3,1)=RIGHT(B3,1),RIGHT(D3,1)=RIGHT(C3,1)),"","、"&RIGHT(D3,1))&IF(OR(RIGHT(E3,1)=RIGHT(B3,1),RIGHT(E3,1)=RIGHT(C3,1),RIGHT(E3,1)=RIGHT(D3,1)),"","、"&RIGHT(E3,1))&IF(OR(RIGHT(F3,1)=RIGHT(B3,1),RIGHT(F3,1)=RIGHT(C3,1),RIGHT(F3,1)=RIGHT(D3,1),RIGHT(F3,1)=RIGHT(E3,1)),"","、"&RIGHT(F3,1))&IF(OR(RIGHT(G3,1)=RIGHT(B3,1),RIGHT(G3,1)=RIGHT(C3,1),RIGHT(G3,1)=RIGHT(D3,1),RIGHT(G3,1)=RIGHT(E3,1),RIGHT(G3,1)=RIGHT(F3,1)),"","、"&RIGHT(G3,1))第五个:不明白什么意思,什么是AC值,什么是红球先试用一下,公式效率不好,我也是小白。

本文到此分享完毕,希望对大家有所帮助。

最新资讯