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

[µo°Ý] ¨Ì¹F¦¨²v¼Æ¾Ú¥­§¡¤À°t¨ú¾ã¼Æª÷ÃB...

[µo°Ý] ¨Ì¹F¦¨²v¼Æ¾Ú¥­§¡¤À°t¨ú¾ã¼Æª÷ÃB...

¨Ì¹F¦¨²v¼Æ¾Ú¥­§¡¤À°t¨ú¾ã¼Æª÷ÃB...
1.¨ú¹F¦¨²vÁ`­p¼Æ¾Ú(G96Àx¦s®æ 3850994)
2.¹êµo¼úª÷¬°¹F100%ªÌ
3.­pºâ¹êµo¼úª÷¬°:¹F¦¨²vÁ`­p¼Æ¾Ú3850994/¹êµo¼úª÷1000000*¨C¦ì¹F¦¨¼Æ¾Ú)



­«­n´£¿ô¬O
¹êµo¼úª÷»Ý¬°¾ã¼Æ¥B¹êµo¼úª÷¦X­pÁ`­p»Ý¬°1000000
¸Ó¤½¦¡¸Ó¦p¦ó³B²z...(¤~¤£·|»~®t1~2¤¸)

0214.rar (8.61 KB)

­n¨ú¾ã¥Bª÷ÃB¬Ûµ¥:
=IF(G2="","",ROUND(G2/SUM(G2:G$95)*(I$1-SUM(H$1:H1)),0))

­Y­n¤½¥­©Ê..¤â°Ê½Õ¾ã..§Y¦³¦h¾lªº, ±q³Ì¤Öªº³v­Ó¥[1..¤£°÷®É, ±q³Ì¦hªº³v­Ó´î1

TOP

¦^´_ 2# ­ã´£³¡ªL

¤ûÂà°®©[...·s¦~§Ö¼Ö

·P®¦¸Ñ´b...
¥u¬O¤£¸Ñ­ì¥»©Ò²£¥Í¤§¼Æ¾Ú¥­§¡¤À°t»~®t...2
¸g¥Ñ
IF(G2="","",ROUND(G2/SUM(G2:G$95)*(I$1-SUM(H$1:H1)),0))
¤½¦¡¬O¦p¦ó±N¨ä¤À°tµ¹¹F¦¨100%ªÌ ?

TOP

¦^´_ 3# cypd

¨C¤À°t¤@­Ó, ­«·s­pºâ¤À°t²v,
§Y¦©±¼¤w¤À°tªº¾lÃB¦A­pºâ¤À°t¤ñ²v¤Îª÷ÃB,
³Ì«á¤@­Ó¥²µM¬O³Ì«á¾lÃB~~

TOP

¦^´_ 4# ­ã´£³¡ªL
·PÁ±zªº»¡©ú
­Y¬O°ÝÃD§Æ±æµ²ªG¯à¥H¹F¦¨²v³Ì¨ÎªÌ¬°²Ä¤@Àu¥ýªº¦Ò¶q
¤½¦¡¬O§_¥i¦æ(­Y¥H»~®t2¬°¨Ò...¹F¦¨²v³Ì¨ÎªÌ²Ä¤@¦W¸É1,²Ä¤G¦W¤]¸É1ªº¤è¦¡...¥H¦¹Ãþ±À)

TOP

¦^´_ 5# cypd

­Y¬O¥H»~®t¬O-2®É¡A¤S¸Ó«ç»ò¤À°t?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# cypd

1) ¤â°Ê¥[´î¬O³Ì¦n¤èªk
2) ®t¼Æ¥i¯à¦h¤]¥i¯à¤Ö
3) ±Æ¦W¥i¯à¦P¦W¦³¦h¤H, ¦p®t¼Æ2, ¦ý²Ä¤@¦W¦³3­Ó, ¤S¶·¦h¤@¹D­pºâ

­Yµw­n¤½¦¡ª½±µ¹F¦¨(¤£ºÞ¦hÁÙ¬O¤Ö, ³£¥Ñ²Ä¤@¦W©¹¤U¥[´î)
j1//¥ý¨ú±o®t²§¼Æ:
=I1-SUMPRODUCT(ROUND((0&G2:G95)/G96*I1,))

h2//
=IF(G2="","",ROUND(G2/G$96*I$1,)+(RANK(G2,G$2:G$95)+COUNTIF(G$1:G2,G2)-1<=ABS(J$1))*SIGN(J$1))

TOP

¦^´_ 7# ­ã´£³¡ªL

­Yµw­n¤½¦¡ª½±µ¹F¦¨(¤£ºÞ¦hÁÙ¬O¤Ö, ³£¥Ñ²Ä¤@¦W©¹¤U¥[´î...³o´N¬O§Ú§Æ±æªºµ²ªG)
j1//¥ý¨ú±o®t²§¼Æ:
=I1-SUMPRODUCT(ROUND((0&G2:G95)/G96*I1,))

·PÁª©¥Dªº¦^´_  ^^
°w¹ï°ÝÃD¦]¨S¦Ò¶qªí¹F²M·¡...
1.°w¹ï­pºâ¼úª÷¨Ì¾Ú»Ý°Ñ¦Ò  J5:J88 ªº¹F 100%¤§¼Æ¾Ú
  ( K Äæ¹F100%¼Æ¾Ú¨t°Ñ¦Ò·~ª÷ÁZ®Ä©Ò­pºâ...»P¹ê»Ú J Äæ¹F100%±Æ§Ç¦³»~®t¡A³y¦¨¹êµo¼úª÷µ¹¿ù)

2.­pºâ¼úª÷Äæ¦ì(L5:L98)¤§¤½¦¡¸Ó¦p¦ó­«·s­×¥¿?
0217.rar (12.37 KB)

TOP

¦^´_ 6# ML089

·PÁª©¥D...
°ÝÃDÂI¤w­«·s¤W¶Ç¸É±Ô»¡©ú...

TOP

¦^´_ 9# cypd


=IF(K5="","",ROUND(K5/K$99*L$3,)+(RANK(J5,J$5:J$98)+COUNTIF(J$4:J4,J5)<=ABS(L$2))*SIGN(L$2))

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD