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

[µo°Ý] IF¥i¥H°µÂù­«§PÂ_¶Ü?

[µo°Ý] IF¥i¥H°µÂù­«§PÂ_¶Ü?

¥ý«e¼g¤F¤@­ÓIF°j°é¦pGÀx¦s®æ
(f17-b17)>0=>ªÅ
(f17-b17)<0=>¦h

¦ý²{¦b·Q­n¦h¥[¤@­Ó§PÂ_¦¡

(f17-b17)>0¥B(f16-f17)>0=>ªÅ
(f17-b17)<0¥B(f16-f17)<0=>¦h

(f17-b17)>0¥B(f16-f17)<0=>0
(f17-b17)<0¥B(f16-f17)>0=>0
½Ð°Ý§Ú¬O­n¥[¦bIF°j°é¤ºªº¸Ü­n«ç»ò§ï©O? Book11.rar (7.17 KB)

¨Ì§AªºÃD·N¦ü¥GÀ³¬O
=IF(B17=0,G16,IF((F17-B17>0)*(F16-F17>0),"ªÅ",IF((F17-B17<0)*(F16-F17<0),"¦h",0)))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

1.¦ü¥G¥iµy¬°Â²¤Æ
=IF(B60=0,G59,IF((F60>B60)*(F59>F60),"ªÅ",IF((F60<B60)*(F59<F60),"¦h",0)))
¦ýµ²ªG·|¦³0²£¥Í
ªÑ¥«¤£¬O¦h´N¬OªÅ,¦³0ªºµ²ªG¬O¹ïªº¶Ü?
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ nickapple ©ó 2010-6-18 15:21 ½s¿è

·PÁ¤W­±¨â¦ì¤j¤j
ªÑ¥«°£¤F¦h ªÅ¥H¥~ ÁÙ¦³"ªÅ¤â"­ò
0=ªÅ¤â ¤£°µ³æ^^ ¤£¹L¹ê»Ú¤W©Mºc·QÁÙ¬O·|¦³¸¨®t
µ¥µ¥§Ú¦A·Q¬Ý¬Ý­n«ç¥Î¤å¦rªí¹F¥X¨Ó

TOP

¤å¾Ç³y¸Ú¤£¦n ¦³¬Ý¤£À´ªº¦a¤èÁٽЧiª¾
ªþ¥ó¤º§Ú¤w¸g±N¤j¤j­Ìªºª©¥»©ñ¤J¤F Book11.rar (17.63 KB)
¦ý¤ñ¹ï¤U¨ÓÁöµM¬O¦¨¥\ªº ¦ý¨Ã«D¤p§Ì©Ò·Q­nªº
©Ò¥H¦³¤À¦¨§ï«e §ï«á ©M²z·Q­È
²³æªº»¡
§PÂ_F<B¥BF16<F17
Åã¥Ü¦hªº®É­Ô
´N¤£·|¥h¤ñ¸ûFÀx¦s®æ¤W¤Uªº­È ¤]´N¬O»¡¤£·|¥h§PÂ_F16<F17
¥u·|§PÂ_F>B OR F<B ¦pªGF>B=ªÅ F<B=¦h OR 0

³oÃä¤ñ¸û¦³°ÝÃDªº´N¬O0³o¦a¤è
¦pªG¦hÅܦ¨0ªí¥ÜF>B ¥BF16<F17
¦hÅܦ¨ªÅªí¥ÜF>B¥BF16>F17

F>B¤Ï¤§¥çµM

¦ý§Ú·Q­nªº§PÂ_¬yµ{«o¬O³o¼Ë(¥H20Ä欰Á|¨Ò)
·íF19Åã¥Ü¬°¦h
20Äæ¥u§PÂ_F¤ÎB­È ¦pªGF>Bªº¸Ü ¥ýÅã¥Ü0 ¦pªGF19>F20¤~·|Åã¥ÜªÅ

³o¬O§Ú¥Ø«eªº·Qªk @@
«ô°U¦U¦ì¤j¤j¤F(SORRY Å޿褣¤Ó¦n ¤£ª¾¹D¦U¦ì¦³¨S¦³¬Ý±oÀ´)

TOP

§Ú­«·s§ï¹L¤@¦¸ ½Ð¦U¦ì¤j¤jÀ°¦£¤@¤U!
³o¦¸¤À¶}¥Î¨â­ÓÀx¦s®æ ¤À§O¬°G©MH

IÀx¦s®æ:
¥ý§PÂ_G©MH,¦pªGG17=¦h,H17=1©ÎG17=ªÅ,H17=1,§PÂ_F­È
­YG17=¦h,F16>F17,I=¦h
­YG17=ªÅ,F16<F17,I=ªÅ
¨ä¾l,I=0

Book11.rar (19.51 KB)

TOP

I17=IF((G17="¦h")*(F16>F17),"¦h",IF((G17="ªÅ")*(F16<F17),"ªÅ",0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂhsieh¤j ÁöµM¤£¬O§Ú·Q­nªº ¦ý§A«oµ¹§Ú¤@­Ó¤è¦V

I17=IF((G17="¦h")*(H17=1)*(F16<F17),"¦h",IF((G17="ªÅ")*(H17=1)*(F16>F17),"ªÅ",0))

³o¤~¬O§Ú·Q­nªº ÁöµMÂ÷²z·Q­ÈÁÙ¬O¦³ÂI¶ZÂ÷^^
¦ý­Y¬O±N JÄæ©w¸q¤@¤U:
J17=IF(I17="¦h","¦h",IF(I17="ªÅ","ªÅ",0))

¥t¥~·Q½Ð±Ð J17¥i¥H¸òI17¨Ö¦b¤@¶ô°µÂ²¤Æ¶Ü? Book11.rar (18.24 KB)

TOP

«á¨Ó §Ú¸Õ¥X¨Ó¤F

I17=IF((I16="¦h")*(H17=0),"¦h",IF((I16="ªÅ")*(H17=0),"ªÅ",IF((G17="¦h")*(H17=1)*(F16<F17),"¦h",IF((G17="ªÅ")*(H17=1)*(F16>F17),"ªÅ",0))))

¦ýÁ`ı±o§PÂ_¦¡¤Óªø,¬O§_¦³¿ìªk²¤Æ©O? Book11.rar (18.11 KB)

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-6-23 08:55 ½s¿è

°Ñ¦Ò¬Ý¬Ý
I17=IF(H17,IF((G17="¦h")*(F16<F17)+(G17="ªÅ")*(F16>F17),G17,0),I16)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD