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

[µo°Ý] ½Ð°Ý§Ú°µªº¹ï¶Ü¡H(ÁÙ¦³¨ä¥L¤èªk¶Ü¡H)

[µo°Ý] ½Ð°Ý§Ú°µªº¹ï¶Ü¡H(ÁÙ¦³¨ä¥L¤èªk¶Ü¡H)

¥»©«³Ì«á¥Ñ bvge ©ó 2011-3-19 17:40 ½s¿è

¬O§Ú¦Û¤vªººc·Q¡A§Ú¦Û¤v¦³°µ¤F5­Ó¡A¤£ª¾¹D¹ï¶Ü¡H
¥t¥~6­Ó¤£·|°µ¡A½Ð·|ªº«e½úÀ°¦£¶ñ¤J
ÁÂÁ¡I

¤Ñ¼Æ.rar (2.62 KB)

·PÁÂdonald ±Ð¾É
¶ZÂ÷65·³±j¨î°h¥ð  ¦³¶ñ¤J¤F
¬O¨úB4ªº¦~ÄÖ¨Ó´«ºâ

¦A½Ð°Ý
¦pªG¥Î¥t¤@ºØ¤è¦¡
´N¬Oª½±µ§ì¨ú ¥X¥Í¦~¤ë¤é(B2)ªº "¦~"
¨Ó´«ºâ¶ZÂ÷ 65 ·³±j¨î°h¥ð
¤£ª¾¹D­n¦p¦ó¤U¤½¦¡¡H
ÁÂÁ¡I

¤Ñ¼Æ.rar (3.37 KB)

TOP

³Ò°h¨­pºâ
²{¦b¤v¸g¤£±`¥Î¤F©O
brabus µoªí©ó 2011-3-19 19:40



§A¤£·|´N¤£­n¾x¤F
§Ú¬O¿ï¨.

TOP

®@
¤p¤ß¤W­­¥u¦³45­Ó¤ë®@
¨Ö60·³¥H¤W¤u§@¦~¸ê¥u¦³50­Ó¤ë®@
jeason

TOP

¤p¤ß???
¤p¤ß¤°»ò?
¬O©È»â¤Ó¦hÁÙ¬O¤Ó¤Ö?
¥H¤u§@30¦~¨C¤ëÁ~³£5¸U­p
°h¥ð®É15*2+(30-15)=45°ò¼Æ
45*50000=2250000

·s¨î50000*6%*12¤ë*30¦~=108¸U
¥»ª÷¬Ý225>108

¦ý¥[¤W·s¨î·s¤H®É¥i¯àÁ~¤£¨ì1/2
¥i¥H¦s´Ú²£¥Í½Æ§Q
¦³³q¿±ªº°ÝÃD
¨¥¼°hÂ÷¾°ÝÃD
¤½¥q¼µ¤£¨ì§A°h¥ð,©Î´£¼·¤£¨¬
¤¤¶¡ªÈªÈ¸¯¸¯,²z¤£²Mªº
´Á±æ­È½Ö°ª­n¦Û¤v§PÂ_

Á`¤§Â¨îÀ³¾á¤ßªº¬O¥i§_°µ¨ì°h¥ð
¦Ó¤£¬O»â¦h»â¤Öªº°ÝÃD
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

§Ú¨¦~¸ê¶W¹L30¦~¤w¸g¬O¤W­­¤F¡A
¥h¦~¤S§ï¬°·s¨î¡A²{¦b¤½¥q¨C­Ó´£¼·6%¤J±b¤á....

³o¨Ç³£¬OÃD¥~¸Ü
§Ú¥D­n¬O­n°Ý3¼Óªº°ÝÃD
¬Ý¦³¨S¦³«e½ú¯à«ü¾É¤@¤U
ÁÂÁ¡I

TOP

­ìB20=IF(B4>=65,"¸Ó°h¥ð",DATEDIF(TODAY(),DATE(YEAR(B2)+65,MONTH(B2),DAY(B2)),"y"))

B20=IF(DATEDIF(B$2,TODAY(),"Y")>=65,"¸Ó°h¥ð",DATEDIF(TODAY(),EDATE(B$2,65*12),"Y"))
B21=IF(DATEDIF(B$2,TODAY(),"Y")>=65,"¸Ó°h¥ð",DATEDIF(TODAY(),EDATE(B$2,65*12),"YM"))
B22=IF(DATEDIF(B$2,TODAY(),"Y")>=65,"¸Ó°h¥ð",DATEDIF(TODAY(),EDATE(B$2,65*12),"YD"))
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

·PÁÂdonald ªº¿EÀy¡AÂÔ°O¦b¤ß¡I

TOP

­ìB20=IF(B4>=65,"¸Ó°h¥ð",DATEDIF(TODAY(),DATE(YEAR(B2)+65,MONTH(B2),DAY(B2)),"y"))

B20=IF(DATEDIF ...
gong µoªí©ó 2011-3-20 16:48



   
·PÁÂgong ª©¤jªº«ü¾É
¦ý...¦n¹³¦³¿ù»~
®M¥Î¤§«á¥X²{  #NAME?
¤£ª¾¹D¿ù¦b±q¨º¡A¤]¤£ª¾¹D­n±q¨º¸Ì§ï...
ÁÙ¬O·PÁ¡I

TOP

¨ä¥Lªº¥i¥H¬Ýªº¨ì¶Ü?

¥i¯à¬OEDATE()
­n¤u¨ã>¼W²§¶°>¤ÀªR¤u¨ã½c¥´¤Ä
¤£¹LDATEDIF¥i¥H¥ÎEDATEÀ³¸Ó¤]¥i¥Hªº
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD