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

[¤À¨É] EXCEL¨ç¼Æ¦p¦ó¼g¦¨¤@µ§½Æ¦X¦¡¨ç¼Æ

[¤À¨É] EXCEL¨ç¼Æ¦p¦ó¼g¦¨¤@µ§½Æ¦X¦¡¨ç¼Æ

¤@¡B¥N¸¹¦³ABCDE

¤G¡B±q1´`§Ç¨ì6¡A¦pªG­n¥ÎEXCEL¨ç¼Æ¼g¦¨¤@µ§½Æ¦X¦¡¨ç¼Æ?

1.D=0¡A§Y=0
2.E-B<=0¡A§Y=D
3.E-B>0¡A§Y=E-B-A<=0¡A§Y=D
4.E-B>0¡A§Y=E-B-A>0¡A§Y=E-B-A-C<=0¡A§Y=D
5.E-B>0¡A§Y=E-B-A>0¡A§Y=E-B-A-C>0¡A§Y=E-B-A-C-D>0,§Y=NG
6.E-B>0¡A§Y=E-B-A>0¡A§Y=E-B-A-C>0¡A§Y=E-B-A-C-D<=0,§Y=(E-B-A-C-D)*-1




=IF(D=0,0,IF(E-B<=0,D,IF((E-B-A<=0),D,IF((E-B-A-C<=0),D,IF((E-B-A-C-D>0),"NG",(E-B-A-C-D)*(-1))))))

=IF(D=0,0,
§P©w1.D=0¶Ü
¬O--Åã¥Ü0...§_--°õ¦æ¤U¤è

=IF(D=0,0,IF(E-B<=0,D,
§P©w2.E-B<=0¶Ü(²Ä¤@­Ó§P©w¤w¸g½T»{D¤£µ¥©ó0)
¬O--Åã¥ÜD...§_--°õ¦æ¤U¤è

=IF(D=0,0,IF(E-B<=0,D,IF((E-B-A<=0),D,
§P©w3.E-B-A<=0¶Ü(²Ä¤G­Ó§P©w¤w¸g½T»{E-B¤£µ¥©ó¤p©ó0)
¬O--Åã¥ÜD...-§_--°õ¦æ¤U¤è

=IF(D=0,0,IF(E-B<=0,D,IF((E-B-A<=0),D,IF((E-B-A-C<=0),D,
§P©w4.E-B-A-C<=0¶Ü(²Ä¤T­Ó§P©w¤w¸g½T»{E-B¤ÎE-B-A¤£µ¥©ó¤p©ó0
¬O--Åã¥ÜD...§_--°õ¦æ¤U¤è

=IF(D=0,0,IF(E-B<=0,D,IF((E-B-A<=0),D,IF((E-B-A-C<=0),D,IF((E-B-A-C-D>0),"NG",(E-B-A-C-D)*(-1))))))
§P©w5.E-B-A-C-D>0¶Ü(²Ä¥|§P©w¤w¸g½T»{E-B¤ÎE-B-A¤ÎE-B-A-C¤£µ¥©ó¤p©ó0
¬O--Åã¥ÜNG...§_--Åã¥Ü(E-B-A-C-D)*-1


°O±oEXCEL¦b¤@®æÀx¦s®æ¤º¥u¯à¦³5­ÓIF
¦pÁÙ­nÄ~Äò§PÂ_´N­n¦h¥Î¤@­ÓÀx¦s®æ¥t¥~¦h¼g

¦pªG¹J¨ì³oºØ±¡ªp¡]¤@­ÓÀx¦s®æ¶W¹L5­Óif¡^ ¬O§_¥ÎVBA¥i¥H¹ê²{©O¡H

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD