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

[µo°Ý] ²Õ¦XÀx¦s®æ®É¦p¦ó¥O"<"¡B">"µ¥²Å¸¹¤£³QÃѧO¬°¤å¦r

[µo°Ý] ²Õ¦XÀx¦s®æ®É¦p¦ó¥O"<"¡B">"µ¥²Å¸¹¤£³QÃѧO¬°¤å¦r

A:CÄ欰¸ê®Æ¡A
°²³]¦bE1¿é¤J"B"¡AF1¿é¤J"<"¡AG1¿é¤J"60"¡A
«h¦bD:DÄæ«h±N§P§O¬O§_º¡¨¬E1:G1©Ò¿é¤JªºªF¦è¡A
§YD1ÀˬdIF(B1<60,"TRUE","FALSE")¡B
D2ÀˬdIF(B2<60,"TRUE","FALSE")¡B
¦p¦¹Ãþ±À¡C

¥Ø«e¹J¨ìªº°ÝÃD¬ODÄæŪ¨úF1ªº"<"²Å¸¹®É·|±N¥¦§P§O¬°¤å¦r¡A
§Ú»Ý­nªº¬ODÄæÀ´±oB1<60,B2<60,..¬O¤@±øÅÞ¿è¦Ó¤£¬O¤å¦r¡C

«ôÁ¡ã

=CHOOSE(MATCH(F1,{"<","=",">"}),E1<G1,E1=G1,E1>G1)

TOP

©w¸q¦WºÙx
¤½¦¡=EVALUATE(Sheet1!$E$1&ROW()&Sheet1!$F$1&Sheet1!$G$1)

DÄ椽¦¡=x
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¤W­±¨â¦ì¤j¤jªººB´n¸Ñµª¡I
¬Û¸û¤§¤U¦ü¥GHsieh¤j¤jªº¤èªk§ó¨ãÆF¬¡©Ê¡A¦Ó¥BEVALUATE()¨ç¼Æ¥O±Í¤H¼W¼s¨£»D¡C
¦A¦¸·P¿E¨â¦ìªº¬Û§U¡C

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD