excel 麻烦大神们帮忙简化下列公式?该公式的意思是判断3D号码升降凹凸,如123升,321降,132凸.213凹,122偏,111平,升用1表示,降2,凹3,凸4,平5,偏6!公式如下:=IF(ISERROR(IF(AND(LEFT(B2,1)-MID(B2,2,1)0),2,"")&IF(AND(
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/19 01:22:03
![excel 麻烦大神们帮忙简化下列公式?该公式的意思是判断3D号码升降凹凸,如123升,321降,132凸.213凹,122偏,111平,升用1表示,降2,凹3,凸4,平5,偏6!公式如下:=IF(ISERROR(IF(AND(LEFT(B2,1)-MID(B2,2,1)0),2,](/uploads/image/z/11274943-31-3.jpg?t=excel+%E9%BA%BB%E7%83%A6%E5%A4%A7%E7%A5%9E%E4%BB%AC%E5%B8%AE%E5%BF%99%E7%AE%80%E5%8C%96%E4%B8%8B%E5%88%97%E5%85%AC%E5%BC%8F%3F%E8%AF%A5%E5%85%AC%E5%BC%8F%E7%9A%84%E6%84%8F%E6%80%9D%E6%98%AF%E5%88%A4%E6%96%AD3D%E5%8F%B7%E7%A0%81%E5%8D%87%E9%99%8D%E5%87%B9%E5%87%B8%2C%E5%A6%82123%E5%8D%87%2C321%E9%99%8D%2C132%E5%87%B8.213%E5%87%B9%2C122%E5%81%8F%2C111%E5%B9%B3%2C%E5%8D%87%E7%94%A81%E8%A1%A8%E7%A4%BA%2C%E9%99%8D2%2C%E5%87%B93%2C%E5%87%B84%2C%E5%B9%B35%2C%E5%81%8F6%21%E5%85%AC%E5%BC%8F%E5%A6%82%E4%B8%8B%EF%BC%9A%3DIF%28ISERROR%28IF%28AND%28LEFT%28B2%2C1%29-MID%28B2%2C2%2C1%290%29%2C2%2C%22%22%29%26IF%28AND%28)
excel 麻烦大神们帮忙简化下列公式?该公式的意思是判断3D号码升降凹凸,如123升,321降,132凸.213凹,122偏,111平,升用1表示,降2,凹3,凸4,平5,偏6!公式如下:=IF(ISERROR(IF(AND(LEFT(B2,1)-MID(B2,2,1)0),2,"")&IF(AND(
excel 麻烦大神们帮忙简化下列公式?
该公式的意思是判断3D号码升降凹凸,如123升,321降,132凸.213凹,122偏,111平,升用1表示,降2,凹3,凸4,平5,偏6!公式如下:
=IF(ISERROR(IF(AND(LEFT(B2,1)-MID(B2,2,1)0),2,"")&IF(AND(LEFT(B2,1)-MID(B2,2,1)>0,MID(B2,2,1)-RIGHT(B2,1)0,MID(B2,2,1)-RIGHT(B2,1)
excel 麻烦大神们帮忙简化下列公式?该公式的意思是判断3D号码升降凹凸,如123升,321降,132凸.213凹,122偏,111平,升用1表示,降2,凹3,凸4,平5,偏6!公式如下:=IF(ISERROR(IF(AND(LEFT(B2,1)-MID(B2,2,1)0),2,"")&IF(AND(
=IF(AND(MID(B2,2,1)=MID(B2,1,1),MID(B2,2,1)=MID(B2,3,1)),5,IF(OR(MID(B2,2,1)=MID(B2,1,1),MID(B2,2,1)=MID(B2,3,1)),6,IF(MID(B2,2,1)>MID(B2,1,1),IF(MID(B2,2,1)>MID(B2,3,1),4,1),IF(MID(B2,2,1)>MID(B2,3,1),2,3))))