excel判断奇偶比例，A1=1,B1=2.如果A1B1奇偶比为1:1，则在C1返回0.这段公式怎么写啊求帮助
excel,A1,B1,C1,\u6211\u7684\u95ee\u9898\u662fC1\u4e0d\u7b49\u4e8eA1B1\u503c\u65f6\u8fd4\u56de0\uff0c\u7b49\u4e8e\u5c31\u8fd4\u56de1\uff0c\u516c\u5f0f\u600e\u4e48\u505a\uff0c\u8bf7\u5e2e\u52a9\u6211\uff0c\u8c22\u8c22\u60a8D1\u8f93\u5165
=IF(AND(C1=A1,C1=B1),1,0)
\u56de\u8f66\u3002
=if(and(min(A1,B1)6),max(A1,B1),0)
不是1:1呢？C1等于什么？
下图做了一个不是1:1 C1为空值的例子
使用下列任一公式
=IF(MOD(A1,2)=MOD(B1,2),0,"")
=IF(MOD(A1,2)<>MOD(B1,2),"",0)
简化如下
=IF(MOD(A1,2)=MOD(B1,2),,"")
=IF(MOD(A1,2)<>MOD(B1,2),"",)
不会写 这个啊 ！
这个我也不会写啊
绛旓細濡傚浘锛孊1鍏紡=IF(MOD(A1,2),"濂囨暟","鍋舵暟")
绛旓細=if(and(A1>0,isodd(A1)=false,isodd(B1)),"鏄","鍚")
绛旓細鍘熺悊锛歁OD鏄彇浣欐暟鐨勫嚱鏁帮紝灏咥1鐨勫奸櫎浠2鍙栦綑鏁帮紝濡傛灉浣欐暟绛変簬0閭ｄ箞鑲畾灏辨槸鍋舵暟锛屼綑鏁扮瓑浜1锛堜竴瀹氫細绛変簬1锛夐偅涔堣偗瀹氬氨鏄鏁般傚叕寮忥細=IF(MOD(A1,2)=0,"鍋舵暟","濂囨暟") 銆
绛旓細ISODD鍑芥暟灏辨槸鍒ゆ柇鑻ヤ负濂囨暟锛屽垯杩斿洖TRUE銆侷SEVEN鍑芥暟鏄垽鏂嫢涓哄伓鏁板氨杩斿洖TRUE銆
绛旓細濂囧伓姣斾緥鍏紡=TEXT(SUMPRODUCT((MOD(A1:E1,2)<>0)*1),"0")&":"&TEXT(SUMPRODUCT((MOD(A1:E1,2)=0)*1),"0")澶у皬姣斾緥鍏紡=TEXT(SUMPRODUCT((B1:F1>17)*1),"0")&":"&TEXT(SUMPRODUCT(((B1:F1<=17)*1)*1),"0")
绛旓細姣斿鎶婁笁涓暟鏀惧湪A1鍒癈1涓 鏈澶х殑 =max(a1:c1)鏈灏忕殑 =min(a1:c1)涓棿澶х殑鏁 =median(a1:c1)鍒ゆ柇濂囧伓A2杈撳叆 =if(mod(a1,2),"濂囨暟","鍋舵暟") 寰鍙虫媺鍒癈2 鍒ゆ柇璐ㄦ暟鍚堟暟A3杈撳叆 =IF(OR(A1={0,1}),"闈炶川闈炲悎",IF(SUMPRODUCT(--(MOD(A1,ROW(INDIRECT("1:"&INT(SQRT(A1)))=0))...
绛旓細濡傛灉璇ュ嚱鏁颁笉鍙敤锛屽苟涓旇繑鍥為敊璇 #NAME?锛屽畨瑁呭姞杞解滃垎鏋愬伐鍏峰簱鈥濆姞杞藉畯銆傛垨鑰呯敤 =mod(A1,2)鏍规嵁杩斿洖鐨勪綑鏁鍒ゆ柇濂囧伓 Excel娌℃湁鐩存帴鍒ゆ柇璐ㄦ暟鍜屽悎鏁扮殑鍑芥暟.涓嶈繃鍙互鑷繁缁勫悎涓涓:=IF(A1>65536^2-1,"瓒呰繃鍒ゆ柇鑼冨洿",IF(OR(A1<=1,INT(A1)<>A1),"闈炲悎鏁板拰璐ㄦ暟",IF(A1=2,"璐ㄦ暟",IF(OR(INT(...
绛旓細B1杈撳叆 =IF(ISODD(LEFT(A1)),"濂","鍋")&IF(ISODD(MID(A1,2,1)),"濂","鍋")&IF(ISODD(RIGHT(A1)),"濂","鍋")涓嬫媺
绛旓細B2=IF(MOD(A1,2)=0,鍏紡1,鍏紡2)璇存槑锛氬皢A1鐨勫奸櫎浠2鍙栦綑鏁帮紝濡傛灉鏄0閭ｄ箞灏辨槸true灏辨樉绀哄叕寮1 濡傛灉鏄1灏辨槸鏄剧ず鍏紡2 1妤肩殑鍥炵瓟 鐢╥sodd 鎴戞煡浜嗕竴涓嬶紝杩欎釜鍑芥暟EXCEL鏀寔涓嶄簡鐨勶紝浠栧簲璇ユ槸涓涓仛绋嬪簭鐨勶紝鎶婂嚱鏁扮粰璁伴敊浜唦褰撶劧isodd 鏈韩鐨勫姛鑳藉氨鏄鍒ゆ柇濂囧伓鏁鐨勶紝鍙槸涓嶈兘鍦‥XCEL閲岄潰浣跨敤~...
绛旓細浠ュ悓琛ㄤ妇渚嬨1銆佸鍒惰〃1B鍒楁暟鎹埌琛2鐨勬暟鎹湪A鍒楋紝鍦˙鍒楁坊鍔犺緟鍔╁垪锛屽A鍒楀皬鏁扮偣鐨勪竴浣锛屽垽鏂鍋讹紝杈撳叆 =IF(MOD(--RIGHT(TEXT(A1,"0.0")),2),"濂","鍋")2銆侀夋嫨AB鍒楋紝鍦ㄢ滄暟鎹濋夐」涓嬬殑鈥滄帓搴忊濅腑锛岄夋嫨浠鍒椾负涓昏鍏抽敭瀛楋紝A鍒椾负娆℃暟鍏抽敭瀛楋紝鍗囧簭鎺掑簭銆傝瑙侀檮鍥 涓嬪浘A鍒椾负缁撴灉...
