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

[µo°Ý] ìF©óIF¦h±ø¥ó¥Îªk¤½¦¡

=if(I9="¯²¸î",1,0.03)*F9

³o¼Ë¬O§_²³æ¨Ç?

TOP

·PÁ¦U¦ì¼ö¤ß¸Ñµª
«á¨Óµo²{°ÝÃD¤F
¦Û°Ê­pºâ¨º­Óµ²¯u¨S¦³¤Ä¨ì
µM«á¨ä¥¦¤½¦¡¬O§Ú¦Û¤w¤£¤p¤ß¦h«ö1­Ó . ¨Sª`·N¨ì
¤~·|³y¦¨¤½¦¡¨S¦³±a¥X¨Ó

IFªº¥Îªk·Pı«Ü¦hÅܤƥi¥H¹B¥Î

ÁÂÁ¤j®a

TOP

³}¨ì¾Ç¨ì¡A¥H«e³oºØ³£¬O¥ÎIF°j°é©ÎªÌ¥t¥~«Ø¤@­ÓTable¦A·f°tVlookup¡A¤£ª¾¹D¥i¥Hª½±µ¥Î°}¦Cªº¤è¦¡¡A³o¼Ë§ó¥[ª½±µ©úÁA
Adam

TOP

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