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

[µo°Ý] EXCEL~IF¤½¦¡Â²¤Æ°ÝÃD

[µo°Ý] EXCEL~IF¤½¦¡Â²¤Æ°ÝÃD

½Ð°Ý³á

§Ú¦³¥H¤U³o¼Ëªº¼Æ¾Ú
¡@¡@¢Ï¡@¢Ð¡@¡@¢Ñ
1¡@50¡@¤½¾·
2¡@40¡@¤½ªÃ
3¡@20¡@¤½¤É
4¡@30¡@¤½¤ç
5¡@40¡@¤½§J

§Ú³Ì¥D­n¬O­n¦bCÄd§e²{~¥i¯à§Ú"¤½¾·"³o­ÓÄæ¦ì³æ¦ì´«ºâ¬O­n50*1000¡A¥i¬O§Ú¥i¯à"¤½ªÃ"³o­ÓÄæ¦ì¬O­n40/1000
°²³]§Ú¤w¸g¦bC1Äæ¼g¥X¨Ó =IF($B1="¤½¾·", A1*1000,IF($B1="¤½ªÃ",$A1/1000,IF($B1="¤½¤É",$A1*1000,5555555)))

½Ð°Ý§Ú¸Ó¦p¦ó§â³o¨Ç²¤Æ~µM«á¤S¯à¹F¨ì§Ú·Q­nªº©O? ¤å¦r¦³ÂI¦h~­Y¦³¤£À´~½Ð¨£½Ì~Åwªï´£¥X¨Ó¡AÀ°¦£¸Ñ¨M§Úªº§x´b!! ÁÂÁÂ

°Ñ¦Ò¬Ý¬Ý
=CHOOSE(FIND(RIGHT($C2,1),"¾·ªÃ¤É¤ç§J"),1000,1000,1,1,0.001)*B2
²Î¤@Âà´«¦¨¤½¤ç³æ¦ì

¦pªG­n¨ä¥L±ø¥ó½Ð¦Û¦æ­×¥¿
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 2# gong

¦n~ÁÂÁ¤j¤j¡A¥Ø«e¤u§@¦£¸L><~±ßÂI¦A¨Ó¹Á¸Õ¬Ý¬Ý¡A·P®¦!

TOP

¦^´_ 3# fusayloveme

¦pªG¤½¦¡Â²¤Æ¬O²Ä¤@¥Ø¼Ð , ¥Î¬dªí
C1=A1*VLOOKUP(B1,$E$1:$F$5,2,0)

TOP

¦^´_ 2#¡B4# gong register313

«D±`·PÁÂ! À|¸Õ«á~µo²{ªº½T³o¼Ë¤è«K³\¦h! ¦Ó¥B¤S¾Ç¨ì·sªº¨ç¼Æ¹B¥Î! ¤Ó·P¿E¤F!!!

¤]ÁÂÁÂ¥|¼Ó¤j¤jªº«ü¾É!! ­ì«h¤WÁÙ¬O´Â¦V¯à°÷¥Î¨ç¼Æ¸Ñ¨M´N¨ç¼Æ¸Ñ¨M¡A¥H¤£¼W¥[¸É¥RÄæ¦ì¬°¶D¨D~«D±`·P¿E¨â¦ì¤j¤jªºÀ°¦£!!

TOP

¦^´_ 5# fusayloveme

C1=10^(FIND(RIGHT($B1,1),"§J  ¤ç¤ÉªÃ¾·")-4)*$A1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD