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

©w¸q¦WºÙ°ÝÃD

©w¸q¦WºÙ°ÝÃD

½Ð±Ð¤@¤U¡A
§Ú¦b¦WºÙºÞ²z­û«Ø¥ß¤@­Ó¦WºÙMyName
=IF(INDIRECT("A" & ROW())="ABC","Y","N")

Àx¦s®æ¤¤¨Ï¥Î =MyName
«o¥X²{ #VALUE!

½Ð°Ý³o¬O­þ¸Ì³y¦¨ªº¿ù»~?
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

¦^´_ 1# stillfish00


    §Ú´ú¸Õ­ì¦]¬OIF¸ÌªºINDIRECT("A" & ROW())²£¥Íªº­È·|Åܦ¨#VALUE!
¾É­PIFªºµ²ªG¬O#VALUE!
¥i¥H¸Õ¸Õ§ï¦¨=IF(INDEX(INDIRECT("A" & ROW()),1,1)="ABC","Y","N")

TOP

¦^´_ 1# stillfish00

§Ú´ú¸ÕOK
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# naruto018
·PÁ¡A§Ú¤]Áô¬ùı±o¬OINDIRECT¨ºÃä³y¦¨ªº
¥u¬O¤£¥Î©w¸q¦WºÙ¥u¥Î¤½¦¡®É¤SOK
«á¨Ó¬O§ï¥Î=IF(T(INDIRECT("A" & ROW()))="ABC","Y","N")
T±j¨î¨ú¤å¦r¡A¤]¯à¥¿±`´N¬O¤F¡C

¤£¹L·|¥X¿ù¯uªºÆZ³Y²§ªº
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 3# ML089
«z¡A©Ò¥H¬O¦³ªº¹q¸£¥¿±`¦³ªº·|¥X¿ùÂP¡A¥i¥H½Ð±Ð excel ª©¥»¶Ü?
§Ú¦Û¤v¬O excel 2010 32-bit
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 5# stillfish00

EXCEL 2007 32¦ì¤¸

WIN7±M·~ª©64¦ì¤¸
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# stillfish00

MyName §Ú¬O¥Î ="ABC" ¨Ó´ú¸Õ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

©Î³\¬O¤£¦P§@·~Àô¹Ò¸òª©¥»³y¦¨ªº°ÝÃD,¤å¦r§ÎºA¡A¤@«ß±Ä¥Î T ,¦pªG¹J¨ì¬O¼Æ¦r§ÎºA¡A¤@«ß±Ä¥Î N
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD