在做一个打分,分为五项,要控制这五项的分数不能同为一个数字,使用了
if((S4=T4)*(T4=U4)*(U4=V4)*(V4=W4)*(W4=S4)=1,"相同","不相同")加以判断,但始终显示'不相同',求解答如何判断【五个单选按钮组控件值不相同】
if(and(S4=T4,T4=U4,U4=V4,V4=W4,W4=S4),"相同","不相同")
6个都不同?
COUNT(UNIQUEARRAY(SPLIT(CONCATENATE(S4,",",T4,",",U4,",",V4,",",W4,",",S4),",")))=6