- ©«¤l
- 63
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 2007
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2019-4-16
- ³Ì«áµn¿ý
- 2023-3-24
|
Hello, °a¤ªºµ ¤j
¨Ì±zªº°ÝÃD, À³¸Ó¬O5~-25©Ò¶q´úªºÈ, ¬Ò¯à¸É¥¿¦Ü±µªñ50, ¹ï¶Ü?
¦pªG¬Oªº¸Ü, ¨º»ò¤½¦¡À³¸Ó¬O::
J21=IF(H21<>"",0+((I21-$K$6)/5),"")
K21=IF(H21<>"",I21-5*J21,"")
¥H¤W, ÁÙ¬O§Ú¦³©Ò»~¸Ñ, ¦A¤£§[§iª¾. Thanks ~
[H21,I21]=[5,25] ==>[-5ÀÉ, ¸É¥¿¦Ü50]
[H22,I22]=[0,50] ==>[-0ÀÉ, ¸É¥¿¦Ü50]
[H23,I23]=[-5,50] ==>[-0ÀÉ, ¸É¥¿¦Ü50]
[H24,I24]=[-10,75] ==>[+5ÀÉ, ¸É¥¿¦Ü50]
[H25,I25]=[-15,100] ==>[+10ÀÉ, ¸É¥¿¦Ü50]
[H26,I26]=[-20,125] ==>[+15ÀÉ, ¸É¥¿¦Ü50]
[H27,I27]=[-25,150] ==>[+20ÀÉ, ¸É¥¿¦Ü50] |
|