導讀 您好,肖大哥就為大家解答關于大小單雙的判斷方法,大小單雙相信很多小伙伴還不知道,現在讓我們一起來看看吧!1、數據在a1大小:=IF(-- MID...
您好,肖大哥就為大家解答關于大小單雙的判斷方法,大小單雙相信很多小伙伴還不知道,現在讓我們一起來看看吧!
1、數據在a1大小:=IF(-- MID(A1,1,1)>4,"大","小")&IF(-- MID(A1,2,1)>4,"大","小")&IF(--MID(A1,3,1)>4,"大","小")&IF(--MID(A1,4,1)>4,"大","小")&IF(--MID(A1,5,1)>4,"大","小")單雙:=IF(mod(-- MID(A1,1,1),2)=0,"雙","單")&IF(mod(-- MID(A1,2,1),2)=0,"雙","單")&IF(mod(-- MID(A1,3,1),2)=0,"雙","單")&IF(mod(-- MID(A1,4,1),2)=0,"雙","單")&IF(mod(-- MID(A1,5,1),2)=0,"雙","單")。
本文就講到這里,希望大家會喜歡。