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

[µo°Ý] §PÂ_Àx¦s®æ¬O§_¦³­È, ¥[Á`°ÝÃD

[µo°Ý] §PÂ_Àx¦s®æ¬O§_¦³­È, ¥[Á`°ÝÃD

¥»©«³Ì«á¥Ñ 074063 ©ó 2015-3-19 23:48 ½s¿è

¦pªþ¥ó
½Ð°ÝÀx¦s®æD2¦p¦ó§PÂ_C2-B2 , ­YB2¬°ªÅ¥Õ«hC2-A2, ­YB2¦³­È«hC2-B2
123.jpg

=IF(OR(B2="",B2=" "),C2-A2,C2-B2)
ù

TOP

=IF(OR(B2="",B2=" "),C2-A2,C2-B2)
rouber590324 µoªí©ó 2015-3-20 08:21



    ½Ð°Ý­Y­pºâµ²ªG¦³¤p¼ÆÂI¤W»~®t«ç»ò¿ì
    ¦p¥[Á`µ²ªG-0.1 ¦³¨â­Óµ²ªG
   -0.0999999999999996
   -0.100000000000001

TOP

¦^´_ 3# 074063


   ¨º´N§â¥L4±Ë5¤J
=IF(B2="",ROUND(C2-A2,1),ROUND(C2-B2,1))

TOP

¥»©«³Ì«á¥Ñ 074063 ©ó 2015-3-21 00:26 ½s¿è

¦^´_ 2# rouber590324


    ·PÁÂrouber590324  ¤Î lpk187 ¸Ñµª :)

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD