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

[µo°Ý] ·í¥X²{¥Ø¼Ð®É§ïÅܼƦr

[µo°Ý] ·í¥X²{¥Ø¼Ð®É§ïÅܼƦr

¤j®a¦n¤p§Ì·s¨Óªº
¹ïEXCEL¤è­±¤]¬Oªì¤ßªÌ
·Q½Ð°Ý¤@¤U  ·íJ3¥X²{*®É I3Âk¹s
³o¼Ë¦³¿ìªk¶Ü

¶¶±a¤@´£  I3¤¤¦³=IF(G3="","",G3-H3)³o­Ó¨ç¼Æ¦s¦b

·P®¦!!

¦^´_ 1# gghkklkk2004
¸Õ¸Õ¬Ý:I3 ¤½¦¡
=IF(J3="*",0,IF(G3="","",G3-H3))
»¡©ú:
·í J3="*", I3=0,
§_«h, °õ¦æ­ì¤½¦¡ IF(G3="","",G3-H3)

TOP

¦^´_ 2# yen956


    «D±`ÁÂÁ§AªºÀ°§U ·Q½Ð°Ý£¸¨ÇÆ[©À
=IF(J3="*",0,IF(G3="","",G3-H3))

«e­±ªº±ø¥óÂk¹s§Ú¬Ý±oÀ´
¦ý¬O«á­±ªº¬Û´î´N¬Ý¤£À´¤F
¬°¤°»ò­n¥ÎIF?  ³o¤£¬O«Ü²³æªºG3-H3¦Ó¤w¶Ü?

TOP

¦^´_ 3# gghkklkk2004
³o¤£¬O§A­ì¨Óªº¤½¦¡¶Ü?
¡y¶¶±a¤@´£  I3¤¤¦³=IF(G3="","",G3-H3)³o­Ó¨ç¼Æ¦s¦b¡z

IF(G3="","",G3-H3)
»¡©ú:
­Y G3="", «h I3="",
§_«h, I3=G3-H3

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD