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

[µo°Ý] ¦p¦ó¦Û°ÊŪ¨úÄæ¦ì

[µo°Ý] ¦p¦ó¦Û°ÊŪ¨úÄæ¦ì

½Ð°Ý¦U¦ì¤j¤j

°²³]A2=A1*9¡AB1=1¡AB2=2¡AB3=3
A1¦p¦ó¦Û°ÊŪ¨úB1¦ÜB3¤§¼Æ­È¡AµM«á¦A²£¥Í¦ÜC1¡BC2¡BC3
C1¬°A1=B1®É¤§A2¼Æ­È=>C1=9
C2¬°A1=B2®É¤§A2¼Æ­È=>C2=18
C3¬°A1=B3®É¤§A2¼Æ­È=>C3=27

ÁÂÁÂ
QQ

¦^´_ 1# ohyapico
´N·Ó§A´y­zªº¨º¼Ë , ¦bC1,C2,C3 ¶ñ¤½¦¡´N¥i¥H¤F...
C1:  =if(A1=B1,A2,"")
C2:  =if(A1=B2,A2,"")
C3:  =if(A1=B3,A2,"")

TOP

¦ý¬O¨Ì·ÓS¤jªº¤èªkµLªk²£¥X¼Æ­È
¬O­n¦b""¤¤¶ñ¤J¼Æ­È¶Ü???
QQ

TOP

¦^´_ 3# ohyapico
¦p¹Ï , ¥ýÂIC1 , µM«á¦bfx¨ºÃä¶ñ¤W  =if(A1=B1,A2,"")

C2 , C3¦P¤G¼Ó©Ò­z

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD