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

[µo°Ý] ¨Ï¥Î¤@­P©Êªº¤½¦¡,¹F¨ì¥[Á`ªº¥Øªº

[µo°Ý] ¨Ï¥Î¤@­P©Êªº¤½¦¡,¹F¨ì¥[Á`ªº¥Øªº

½Ð°Ý¤j¤j,

·íES:EV <0
«h¨Ì®Æ¸¹¥[Á`EX:FHªº½c¼Æ*¤J¼Æ+²~¼Æ
­YES:EV>0 or ¤£¬°0 or ªÅ¥Õ «h FL:FOÅã¥Ü¬°0

¨Ò¡GES4<0«hFL4«h­n¯àÅã¥Ü­pºâµ²ªG26
²{¦bFL:FO¨Ï¥Îªº¤£¬O¤@­P©Êªº¤½¦¡,
¦p¦ó¨Ï¥Î¤@­P©Êªº¤½¦¡,¹F¨ì¥[Á`ªº¥Øªº?
¤@­P©Ê¤½¦¡´«ºâ½c²~¼Æ.rar (17.14 KB)

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-11-30 12:53 ½s¿è

FL4:
=SUMPRODUCT(OFFSET($EX4,,SUM(COLUMN(A1)*3-3),,2)*$G4^{1,0})*(ES4<0)
©Î
=SUM(INDEX($EX4:$FH4,N(IF(1,COLUMN(A1)*3-{2,1})))*$G4^{1,0})*(ES4<0)
©Î
=MMULT(OFFSET($EX4,,SUM(COLUMN(A1)*3-3),,2),$G4^{1;0})*(ES4<0)

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD