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

[µo°Ý] 2­ÓÀx¦s®æ¤½¦¡¦X¦¨¤@­Ó

[µo°Ý] 2­ÓÀx¦s®æ¤½¦¡¦X¦¨¤@­Ó

½Ð°Ý¦³¨S¦³¿ìªk±N³o2­Ó¤½¦¡¦X¦¨¤@­Ó
=IF(COUNTIF($C18,"(¹ê)*"),$B18,$D18)
=IF(COUNTIF($C18,"(¸Õ)*"),$B18,$D18)




¸ÕµÛ¼g¦¨³o¼Ë«o¨S¿ìªk¦¨¥\
=IF(COUNTIF($C18,{"(¸Õ)*","(¹ê)*"}),$B18,$D18)


³Â·Ð¤F «D±`·PÁÂ

=IF(OR(COUNTIF($C18,{"A*","C*"})),$B18,$D18)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=IF(OR(LEFT($C18,3)={"(¸Õ)","(¹ê)"}),$B18,$D18)

=IF(COUNT(FIND({"(¸Õ)","(¹ê)"},$C18)),$B18,$D18)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤Q¤À·PÁÂ2¦ì ¥i¥H¥Î ¤Ó·PÁ¤F

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD