jessicawu

Eugene¤j¤j~~§ÚÀ´Åo~
¤]ÁÂÁÂGong¤j¤jªº»¡©ú~

©P¤p·d

¦^´_ 1# jessicawu
¤£¦n·N«ä~§Ú¬O·s¤â¡A¥Ø«e¤£¯à¤U¸üÀɮסã¯à³Â·Ð±z±NÀÉ®×±Hµ¹§Ú¶Ü¡H
ÁÂÁ¡I

freeffly

¦^´_ 10# gong


    =LOOKUP(C2,{0,1,3,5,10},{0,7,10,14,15})+(C2>10)*INT(C2-10)
    ½Ð°Ýª©¥D+(C2>10)*INT(C2-10)³oºØ¥Îªkªº³W«h¸òIF¦³¨Ì¼Ë¶Ü
   ¨S³o¼Ë¥Î¹L¤@¶}©l¬Ý«Üª½±µªº±µ¨ü¤F
   ·í¦Û¤v³o¼Ë¥Îªº®É­Ôı±o©Ç©Çªº

p6703

¬Ý¨ì¦U¦ì°ª¤âªº¸Ñ»¡,¯uªºÅý¦Û¤v¨ü¯q¨}¦h.ÁöµMÁÙµLªk¤U¸ü,¦ýÁÙ¬O¥ý·PÁÂ^^

hsiehth

·PÁ¦U¦ì¥ý¶i´£¨Ñ³o»ò¦nªº¸Õºâªí
­n¯d¤U¦n¦nªº³Æ¥Î

swedds

§Ú¬O¤p¾Ç¥Í¤]¬Ý¤£¨ì¦U¦ì¤j¤jªº¸Ñµª~
¦ý¬O¯S¥ðÁÙ¦³¤@­Ó§ó³Â·Ðªº¬O¤Q¦~«á¨C¤@¦~¼W¥[¤@¤Ñ¯S¥ð~
ÁÙ¦³º¡3,5,10¦~®É¨ì12/31¤î,»Ý¥[ªº¯S¥ð¤é,
¦]¬°¥Ø¦bÀ°§Ú­Ì¤H¨Æ·d³o­Ó... ©Ò¥H´£¤@ÂI°ÝÃD....
µ¥·d¦n¦A½Ðµ¹¦U¦ì°ª¤â«ü±Ð¤@¤U~

swedds

ªþ¥ó¬°§ÚÀ°§Ú­Ì¤H¨Æ¬ã¨sªº¯S¥ð­pºâ~
½Ð¦U¦ì¤j¤j¨ó§U«ü¾É~  :)

times

¤£¦n·N«ä~~ª©¥D!!§Ú¤]­è¥[¤J³o°Q½×°Ï,¥i¥H±Hµ¹§Ú¶Ü?
[email protected]  ÁÂÁÂ

knlin

§ÚÁÙ¬O·s¤â¤£¯à¤U¸üÀÉ®×
§V¤O¤É¯Å!

softsadwind

¤U¸ü (41.3 KB)

2013-1-2 14:18

¤gªk·Ò¿û¡A¶Ç²Î²£·~¯S¥ðªº­pºâ¤è¦¡
¯S¥ð³q±`³£¬O«e¤@¦~´Nºâ¦n
©Ò¥H¥Ø«e¬Oºâ¨ì2014¦~©³¥i©ñ¯S¥ð¡C
¦pªG­nÅçÃÒ¤µ¦~©³ªº¯S¥ð
E2=IF(D2="","",(DATE(2012,12,31)-D2)/365)
¦pªG¬O­nºâ¨ì¹j¦~¦~©³
=IF(D2="","",(EOMONTH(DATE(YEAR(TODAY())+1,12,1),0)-D2)/365)

³Ì¤Ö0.5¤Ñ­pºâ
º¡¤@¦~«á¡A¨ì¦~©³­pºâ¯S¥ð¤ñ¨Ò
(¦P²z¡Aº¡¤T¦~¡Aº¡¤­¦~¡Aº¡¤Q¦~)

F2=IF(E2="","",IF(E2<2,IF(E2>1,ROUND((E2-1)*7/0.5,)*0.5,0),7)+IF(E2<4,IF(E2>3,ROUND((E2-3)*3/0.5,)*0.5,0),3)+IF(E2<6,IF(E2>5,ROUND((E2-5)*3/0.5,)*0.5,0),4)+IF(E2<11,IF(E2>10,ROUND((E2-10)*1/0.5,)*0.5,0),1)+IF(E2<26,IF(E2>11,ROUND((E2-11)*1/0.5,)*0.5,0),15))