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

[µo°Ý] ¦r¦ê¤ñ¹ï

[µo°Ý] ¦r¦ê¤ñ¹ï

¦pªG§Ú¦³¨â­ÓÀx¦s®æ¦r¦ê­n°µ¤ñ¹ï.

Àx¦s®æ A : "¤Ñ®ð¦n"
Àx¦s®æ B : ¥u­n¦³¥X²{ "¤Ñ®ð¦n" ªº¦r¦ê´Nºâ¬Û²Å, ©Ò¥H·|¶W¹L3­Ó¦r¥H¤W

¦pªG¬O³o¼Ëªº±ø¥ó­n¦p¦ó³]©O?  ÁÂÁÂ

=IF(ISNUMBER(SEARCH(A1,B1,1)),"¬Û²Å","¤£¬Û²Å")

³o¼Ë??

TOP

=IF(A1="","",IF(COUNT(FIND(A1,B1)),,"¤£")&"¬Û²Å")

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD