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

¥¨¶°µLªk¿ý»s

¥¨¶°µLªk¿ý»s

=IF((MID(H49,1,1)="-"),M49*10000-$G$46*10000,IF((MID(H49,1,1)>"0"),$G$46*10000-M49*10000,IF((MID(I49,1,1)="-"),M49*10000-$I$46*10000,IF((MID(I49,1,1)>"0"),$I$46*10000-M49*10000,IF((MID(J49,1,1)="-"),$K$46*100-M49*100,IF((MID(J49,1,1)>"0"),M49*100-$K$46*100,""))))))

¦U¦ì¦n¡G
        ¤p§Ì·Q±N¥H¤W¨ç¼Æ¿ý¦¨¥¨¶°°õ¦æ¡A¦ý¥X²{¡u¤Ó½Æ²ß¡AµLªk¿ý»s¡C¡v¡A½Ð¦U¦ì«ü±Ð¡IÁÂÁ¡I

¦^´_ 1# tinching
¥Îchr(34)§â"¨ú¥N
¨Ò¦p¦bH1¿é¤J¦¹¤½¦¡
[H1] = "=IF((MID(H49,1,1)=" & Chr(34) & "-" & Chr(34) & "),M49*10000-$G$46*10000,IF((MID(H49,1,1)>" & Chr(34) & "0" & Chr(34) & "),$G$46*10000-M49*10000,IF((MID(I49,1,1)=" & Chr(34) & "-" & Chr(34) & "),M49*10000-$I$46*10000,IF((MID(I49,1,1)>" & Chr(34) & "0" & Chr(34) & "),$I$46*10000-M49*10000,IF((MID(J49,1,1)=" & Chr(34) & "-" & Chr(34) & "),$K$46*100-M49*100,IF((MID(J49,1,1)>" & Chr(34) & "0" & Chr(34) & "),M49*100-$K$46*100," & Chr(34) & "" & Chr(34) & "))))))"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD