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

[µo°Ý] ²Õ´ªí

D2=IF(LEFT(B2,3)=E2,"µL",LEFT(B2,3))

§A­nªº¬O³o¼Ë¶Ü?
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¥»©«³Ì«á¥Ñ kkooo15 ©ó 2016-5-12 20:24 ½s¿è

¦^´_ 3# PJChen

=IF(D2="µL",E2,D2&E2)

OR

=IF(D5="µL",E5,D5&LEFT(E5,3))

DÄæ­n¶ñº¡
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD