½Ð°Ý³á
§Ú¦³¥H¤U³o¼Ëªº¼Æ¾Ú
¡@¡@¢Ï¡@¢Ð¡@¡@¢Ñ
1¡@50¡@¤½¾·
2¡@40¡@¤½ªÃ
3¡@20¡@¤½¤É
4¡@30¡@¤½¤ç
5¡@40¡@¤½§J
§Ú³Ì¥Dn¬On¦bCÄd§e²{~¥i¯à§Ú"¤½¾·"³oÓÄæ¦ì³æ¦ì´«ºâ¬On50*1000¡A¥i¬O§Ú¥i¯à"¤½ªÃ"³oÓÄæ¦ì¬On40/1000
°²³]§Ú¤w¸g¦bC1Äæ¼g¥X¨Ó =IF($B1="¤½¾·", A1*1000,IF($B1="¤½ªÃ",$A1/1000,IF($B1="¤½¤É",$A1*1000,5555555)))
½Ð°Ý§Ú¸Ó¦p¦ó§â³o¨Ç²¤Æ~µM«á¤S¯à¹F¨ì§Ú·Qnªº©O? ¤å¦r¦³ÂI¦h~Y¦³¤£À´~½Ð¨£½Ì~Åwªï´£¥X¨Ó¡AÀ°¦£¸Ñ¨M§Úªº§x´b!! ÁÂÁ |