- ©«¤l
- 25
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 155
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- sp3
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2024-11-22
|
¦^´_ 2# jackyq
§Ú쥻¬O¥ÎÀx¦s®æ¥Î¨ç¼Æ¤½¦¡®M¥Î,¦p4/6¤éªºº¦°±»ù¬O4/1¤éªº¦¬½L»ù®M¤W¤½¦¡
M14Àx¦s®æªº¤½¦¡¬O =IF(F15="","",FLOOR(F15*1.1,LOOKUP(F15*1.1,{0,10,50,100,500,1000},{0.01,0.05,0.1,0.5,1,5})))
º¦°±»ù¤½¦¡
=FLOOR(A1*1.1,LOOKUP(A1*1.1,{0,10,50,100,500,1000},{0.01,0.05,0.1,0.5,1,5}))
¶^°±»ù¤½¦¡
=CEILING(A1*0.9,LOOKUP(A1*0.9,{0,10,50,100,500,1000},{0.01,0.05,0.1,0.5,1,5}))
¦ý¬O¦p¦ó¥Î¥¨¶°ªº¤è¦¡§e²{? |
-
-
2.jpg
(73.31 KB)
|