ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] IF§PÂ_½d³òÀx¦s®æ

[µo°Ý] IF§PÂ_½d³òÀx¦s®æ

¥»©«³Ì«á¥Ñ av8d ©ó 2013-2-19 09:07 ½s¿è

°ÝÃD¤@
D2~D200¤¤¡A¥u­n¨ä¤¤¤@­Ó=4 x 6¡A«hF2=¦³
F2=IF($D$2:$D$200="4 x 6","¦³","")
µª®×¦³®É¦³¥X¨Ó¦³®É¨S¦³
---------------------------------------------------

°ÝÃD¤G
D2~D4¤¤¡A­Y¨ä¤¤¤T­Óµ¥©óªÅ¡A«hF3µ¥©ó"µL"¡A­Y¨ä¤¤¨â­Ó¤£µ¥©óªÅ¡A«hF3µ¥©ó"¦³"¡A¸Ó«ç»ò¤U§PÂ_¡H
F3=IF($D$2:$D$4

¦^´_ 1# av8d
F2=IF(COUNTIF(D2:D200,"4*6"),"¦³","µL")
F3=IF(COUNTA(D2:D4)=2,"¦³","µL")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ loquat ©ó 2013-2-19 15:17 ½s¿è

¦^´_ 1# av8d
  1. °ÝÃD¤@
  2. F2=IF(COUNTIF($D$2:$D$200,"4 x 6"),"¦³","µL")
  3. °ÝÃD¤G
  4. F3=IF(COUNTIF($D$2:$D$4,"")=3,"µL",IF(COUNTIF($D$2:$D$4,"")=1,"¦³","两个ªÅ®æ©Q办¡H"))
½Æ»s¥N½X
¦V°ª¤â学习

TOP

COUNTBLANK()
ss

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD