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

[µo°Ý] EXCEL µLªkÅã¥Ü¹ïÀ³ªº¼Æ¦r ·s¤â½Ð±Ð

°ÝÃD¤G
If(B1="",if(c1="","",c1),B1)

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD