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

­±¿n±Æª©ªº§Q¥Î²v°ÝÃD¡C

­±¿n±Æª©ªº§Q¥Î²v°ÝÃD¡C

½Ð±Ð¦U¦ì°ª¤â¡G

   §Ú¦³¤@­Ó¯x§Î¡Aªø¼e¬O 310*344¡A§Ú·Q±N³o­Ó¯x§Î±Æ¶i¤@­Ó©T©w­±¿nªº½d³ò¸Ì¡Aªø¼e¬O 1250*1000¡C
   
   ¤@¶}©l¡A³Ìª½±µªº·Qªk¬O¡A(1250*1000)/(310*344)=11.72¡A©Ò¥H§Q¥Î²v³Ì°ª®É¡A¥i±Æ¶i11¤ù¡I

   ¦ý¹ê»Ú¦bµe¹Ï±Æª©®É¡A«o¨S¿ìªk±Æ¶i11¤ù!?

   ½Ð°Ýexcel¥i¥H¨D¥X³Ì¨Îªº§Q¥Î²v¶Ü¡H©Î¬O¨D¥X³Ì¦h¥i±Æ¶iªº¤ù¼Æ¡H

   ³Â·Ð¦U¦ì°ª¤â! ÁÂÁÂ!

³o­Ó¦n¹³¬OÅÞ¿è°ÝÃD­C~
ªø1250*1000ªº­±¿n­n©ñ¯x§Î344*310
²Ä¤@­Ó¥i¯à¬O(1250/344)*(1000/310) ´N¬O¯à©ñ¼Æ¶q
²Ä¤G­Ó¥i¯à¬O(1250/310)*(1000/344) ´N¬OÂà¦V¯à©ñ¼Æ¶q
¦A¤ñ¸û³o2ºØµ²ªG¨º¤@ºØ­È³Ì°ª §Y¬°©Ò¨D
·íµM©Ò°£ªº¾l¼Æ¥²¥ýµL±ø¥ó±Ë¥h¡A§_«h¾l¼Æ¬Û­¼­Y¤j©ó§A­n©ñªº¯x§Î
´N·|¥X²{§Aºâ¥X11¶ô«o©ñ¤£¨ì11¶ôªº±¡ªp
±µµÛ§Ú¥Îexce §â¥H¤WÂà´«¬°¤½¦¡
­Ya3=¯x§Îªºªø  b3=¯x§Îªº寛  c3=©T©w­±¿nªºªø  d3=©T©w­±¿nªº寛
«h
=IF(INT(C3/A3)*INT(D3/B3)>INT(C3/B3)*INT(D3/A3),INT(C3/A3)*INT(D3/B3),INT(C3/B3)*INT(D3/A3))
§Y¬°©Ò¨D
À³¸Ó¬O§A©Ò­nªºµª®×§a  §Æ±æ¦³À°§U¨ì§A

TOP

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-2-9 12:08 ½s¿è

¦^´_ 2# crazyching

    =IF(INT(C3/A3)*INT(D3/B3)>INT(C3/B3)*INT(D3/A3),INT(C3/A3)*INT(D3/B3),INT(C3/B3)*INT(D3/A3))
    ³o¼Ëªº¥u¯à±Æ9¶ô ¦ý¬O¹ê»Úªº±Æªk½T¬O11¶ô
   ³o­Ó°ÝÃD¸Óºâ¬O¼Æ¾Ç+ÅÞ¿è  Áٻݭn¦A²`¤J±´°Q~
    §Ú¦Û¤v¨Dºâ¥X¨Óªº¤½¦¡¦p¤U («Üªø~~~~~~~~~~~~~~~)
  =IF((IF(D3-INT(D3/MAX(A3:B3))*MAX(A3:B3)>MIN(A3:B3),INT(C3/MAX(A3:B3))+INT(C3/MIN(A3:B3))*INT(D3/MAX(A3:B3)),INT(C3/MIN(A3:B3))*INT(D3/MAX(A3:B3))))>(IF(C3-INT(C3/MAX(A3:B3))*MAX(A3:B3)>MIN(A3:B3),INT(D3/MAX(A3:B3))+INT(C3/MAX(A3:B3))*INT(D3/MIN(A3:B3)),INT(C3/MAX(A3:B3))*INT(D3/MIN(A3:B3)))),(IF(D3-INT(D3/MAX(A3:B3))*MAX(A3:B3)>MIN(A3:B3),INT(C3/MAX(A3:B3))+INT(C3/MIN(A3:B3))*INT(D3/MAX(A3:B3)),INT(C3/MIN(A3:B3))*INT(D3/MAX(A3:B3)))),(IF(C3-INT(C3/MAX(A3:B3))*MAX(A3:B3)>MIN(A3:B3),INT(D3/MAX(A3:B3))+INT(C3/MAX(A3:B3))*INT(D3/MIN(A3:B3)),INT(C3/MAX(A3:B3))*INT(D3/MIN(A3:B3)))))

    µ²ªG,¦p¤U¹Ï©Ò¥Ü
   
   
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

ÁÂÁ¨â¦ì¤j¤jªº¦^´_

¸g¹L20¤ÀÄÁªº¤â¤uÅçºâ¡A³Ì¨Î¸Ñ¬O~~~~~~~~~hugh0620¤j¤j ¸Ñ¥Xªº  11¶ô

¦ý¬O¤½¦¡¹ê¦b¤Óªø¡A¤£¦n²z¸Ñ..¨þ  §â¤½¦¡¬Ý§¹©~µMªá¤F2¤p®É!!!

TOP

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-2-11 08:57 ½s¿è

¦^´_ 4# robot796

     ±o¨ìªºµ²ªG~ ¬O¥ý¥Î¤âºâ~ ªø¼eªº¥i¯à©Ê~ ¦A¼¶¼g¤½¦¡~
     ¤@¶}©l¼gªº¤½¦¡,¤]¬O¦³¿ù»~~ (¦]¬°©T©w¼gªkªø>¼e)
     ¦ý«á¨Ó§ï±Ämax»Pminªº¤è¦¡~ ³o¼Ë¤£ºÞ¬Oªø>¼e,ÁÙ¬O¼e>ªø
   ³o¼Ë­pºâ¤W´N¤£·|¦³°ÝÃD
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 5# hugh0620
½Ð°ÝHUGH0620¤j¤j:
¦pªG©T©wÅé¿nªº½c¤l,¤Ø¤o¬°ªø1000 ¼e1250 °ª1150¦Óª««~ªºªø 310 ¼e344 °ª280«h¤½¦¡¦p¦ó¼g¥iºâ¥X1½c¥i¸Ë¦h¤Ö­Óª««~?ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-2-14 14:49 ½s¿è

¦^´_ 6# sam858


        «z«¨~ ¦Ò¼Æ¾ÇÃD­ò~ >_<
        ÅܤTºûªºªF¦è~ ·|Åܪº§ó½ÆÂø~ µ¥§Ú·Q·Q¬Ý~... ©Î¬O¨ä¥¦¤j¤j¤w¦³¸Ñªk~
        ´ú¸Õªºµ²ªG~ §Ú¤£ª¾¹D¸Ó«ç»ò§Î®e~
        ­Y¬O­n¼g¤½¦¡ªº¸Ü~ §Ú¨Sªk²Õ¦X°_¨Ó~ ¤ñ¤Gºûªº§ó½ÆÂø«Ü¦h~
        ¦]¬°¥Lªº¸Ñªk¬O¦h²Õ¸Ñ~  ³o­Ó­n½Ð¼Æ¾Ç¯u¥¿¦nªº¨Ó¸Ñ~ À³¸Ó¤~¯àÀ°§A³B²z~
        ´£¨Ñ§Ú°µ¥X¨Óªºµ¹§A°Ñ¦Ò~
        ªþ¥ó¤¤´£¨Ñ¥|ºØ°ò¥»²Õ¦X¸Ñµ¹§A~ ÁÙ¦³¨ä¥L±Æ¦C¤è¦¡§A¥i¥H¦Û¤v·f°t~
        ¦pªG¶È¬O¤Gºû(ªø¼e©Îªø°ª©Î¼e°ª) ¤§«eªº¤½¦¡¬O¥i¥H®M¥Î~
        ¶È°O­ò~ ¤£ºÞ«ç»òª±~
         1. ª`·Nªø¼e°ª¬O§_¶W¥X½c¤lªº¼Æ­È
      2.ª««~ªºªø¼e°ª¤£¯à­«ÂÐ
        [attach]4721[/attach]

­±¿n±Æª©ªº§Q¥Î²v°ÝÃD_ªø¼e°ª.rar (3.1 KB)

¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦n¹³¬OºÞ²z¼Æ¾Çªº½u©Ê¥N¼Æ°ÝÃD,
¸Ë³fÂdºâ¤~¿n¥Î,­n³W¹º¯È½c+¤º®e¥]¸Ë¤è¦¡¨Ï¥Î
(´X­Ó¤@§ô,¤@¼h´X§ô,Â\´X¼h)»Ý¨D§÷®Æ
¥ÍºÞ¦n¹³·d³o­Ó,¥i¬O¦­§Ñ¤F

¤£ª¾excelªº³W¹º¨D¸Ñ¬O§_¦X¥Î,§Ú¤£·|¥Î
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 8# gong

ÁÂÁÂhugh0620¤Îgong ¤j¤j:
¦¹°ÝÃD¥¿¬O¦b­ÜÀxµo¥Í³f«~¸Ë½c©Ò­±Á{¤½¦¡­pºâÃøÃD,¸Ë³f¯È½c©T©w¦³´XºØ,¦ý¨C¤Ñ¸Ë¸üª««~¼Æ¶q«~¶µ¤£¤@©w,®³¤Ó¤j¯È½c¸Ë®ö¶O¯È½c¤Î¹B¶O,¸Ë¤Ó¤p¯È½c«h¶·¦A¥[¸Ë¥t¤@¥u¯È½c¥ç¬O®ö¶O,¬G¬Ý¬Ý«e½ú°ª¤â们¯àÀ°¦£¸Ñ¦¹§x´b!

TOP

hugh0620 ¤j¤j
§Ú¥Î¨ä¥L¤Ø¤o¡A®M¥Î§Aªº¤½¦¡¡A³Ì¨Î¥¿¸Ñ¡C
§Ú¥Î¯x§Îªø¼e210*151.06¡A³o­Ó¯x§Î±Æ¶i369*470ªº½d³ò¸Ì¡A
±o¨ìªºªº¸Ñµª=5¡A¥Î¤âÅçºâ½T¹ê¬O5¤ù¡C
¥H³o­Ó¤Ø¤o¬°¨Ò¡A­n«ç»ò¼W¥[§PÂ_¦¡¡A¤~¥i¥Hª¾¹D±Æª©¤è¦¡¡H

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD