- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 239
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-4
|
¦^´_ 1# tinching
¥Îchr(34)§â"¨ú¥N
¨Ò¦p¦bH1¿é¤J¦¹¤½¦¡
[H1] = "=IF((MID(H49,1,1)=" & Chr(34) & "-" & Chr(34) & "),M49*10000-$G$46*10000,IF((MID(H49,1,1)>" & Chr(34) & "0" & Chr(34) & "),$G$46*10000-M49*10000,IF((MID(I49,1,1)=" & Chr(34) & "-" & Chr(34) & "),M49*10000-$I$46*10000,IF((MID(I49,1,1)>" & Chr(34) & "0" & Chr(34) & "),$I$46*10000-M49*10000,IF((MID(J49,1,1)=" & Chr(34) & "-" & Chr(34) & "),$K$46*100-M49*100,IF((MID(J49,1,1)>" & Chr(34) & "0" & Chr(34) & "),M49*100-$K$46*100," & Chr(34) & "" & Chr(34) & "))))))" |
|