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

excel¨ç¼Æ¬O§_¥i¥HÂনVBA

excel¨ç¼Æ¬O§_¥i¥HÂনVBA

¦U¦ì¥ý¶i
¦]©È¦³¦P¨Æ·|±à§R°£excel¨ç¼Æ
©Ò¥H§Ú·Q³]©w¦bVBA¤¤
¬O§_¥i±N¤U¦C»yªk¼g¦¨VBA

=IF(M2="TFS","TFS",IF(M2="ET10/25","11/28",IF(M2="ET1.1/2.2","11/22",IF(M2="ET1.1/2.8","11/28"))))


ÁÂÁÂ!
Just do it.

¦^´_ 3# prin.huang


ÁÂÁ¦^´_  §Ú¦A¸Õ¸Õ
Just do it.

TOP

activesheet.RANGE("A1")=APPLICATION.WORKSHEETFUNCTION.IF(M2="TFS","TFS",IF(M2="ET10/25","11/28",IF(M2="ET1.1/2.2","11/22",IF(M2="ET1.1/2.8","11/28"))))

TOP

¦^´_ 1# jsc0518


§Ú¦Û¤v¤w¬ã¨s¥X¨Ó¤F
¥Î IF-ELSEIF
Just do it.

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD