ªð¦^¦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 : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD