鏈枃妗ｅ瀵逛綘鏈夊府鍔╋紝璇峰府蹇欎笅杞芥敮鎸侊紒
ACCESS
鏌ヨ璁捐鍣ㄤ腑锛屾潯浠惰〃杈惧紡鐨勭敤娉?/p>
1.
甯搁噺
绫诲瀷
鏁板瓧鍨?/p>
鏂囨湰鍨?/p>
鏃ユ湡鏃堕棿鍨?/p>
鏄?/p>
/
鍚﹀瀷
渚嬪瓙
123
3.14
鈥?/p>
浜庨挦楣?/p>
鈥?/p>
鈥?/p>
a102
鈥?/p>
#2013-4-20#
#1988-2-9 14:52:30#
True,yes,on,-1
False,no,off,0
2.
瀛楁寮曠敤
鍦ㄦ煡璇㈢殑鏉′欢琛ㄨ揪寮忎腑鑻ュ紩鐢ㄥ瓧娈碉紝闇�瑕佷娇鐢?/p>
[
瀛楁鍚?/p>
]
鐨勬牸寮忋�傚
[
濮撳悕
]
銆?/p>
濡傛灉闇�瑕佹寚鏄庤瀛楁鎵�灞炵殑鏁版嵁婧愶紝鍒欒鍐欐垚
[
鏁版嵁琛ㄥ悕
]![
瀛楁鍚?/p>
]
鐨勬牸寮?/p>
(
娉ㄦ剰锛?/p>
鑻辨枃鏍囩偣闂
)
銆?/p>
3.
鍑芥暟
鍑芥暟鍦ㄦ潯浠惰〃杈惧紡鍜?/p>
VBA
涓兘閫傜敤銆?/p>
鏁板鍑芥暟
鏍煎紡
鍚嶇О涓庡姛鑳?/p>
绀轰緥鍙婄粨鏋?/p>
Abs
锛?/p>
<
鏁板�艰〃杈惧紡
>
锛?/p>
缁濆鍊煎嚱鏁?/p>
杩斿洖涓�涓暟鐨勭粷瀵瑰�?/p>
Abs(-4.83)= 4.83
Abs(-25/5)=5
Int
锛?/p>
<
鏁板�艰〃杈惧紡
>
锛?/p>
鍚戜笅鍙栨暣鍑芥暟
鍙傛暟涓鸿礋鍊兼椂杩斿洖灏忎簬绛変簬鍙傛暟鍊?/p>
鐨勬渶澶ц礋鏁?/p>
Int(3.56) =3
Int(-3.56)=-4
Fix
锛?/p>
<
鏁板�艰〃杈惧紡
>
锛?/p>
鍙栨暣鍑芥暟
鍙傛暟涓鸿礋鍊兼椂杩斿洖澶т簬绛変簬鍙傛暟鍊?/p>
鐨勬渶灏忚礋鏁?/p>
Fix(3.56)=3
Fix(-3.56)=-3
Sqr
锛?/p>
<
鏁板�艰〃杈惧紡
>
锛?/p>
寮�骞虫柟鍑芥暟
璁＄畻鍙傛暟鐨勫钩鏂规牴锛堝弬鏁颁笉鑳戒负璐?/p>
鏁帮級
Sqr(9)=3
Round
锛?/p>
<
鏁板�艰〃杈惧紡
1>
,
<
鏁板�艰〃杈惧紡
2>
锛?/p>
鍥涜垗浜斿叆鍑芥暟
瀵?/p>
<
鏁板�艰〃杈惧紡
1>
鐨勫�兼寜
<
鏁板�艰〃杈?/p>
寮?/p>
2>
鎸囧畾灏忔暟浣嶆暟杩涜鍥涜垗浜斿叆
娉ㄩ噴
:1
銆?/p>
<
鏁板�艰〃杈惧紡
2>
濡傛灉缂虹渷鍒?/p>
鍑芥暟杩斿洖鏁存暟鍊笺�?/p>
2
銆?/p>
濡傛灉
<
鏁板�艰〃杈?/p>
寮?/p>
2>
鐨勫�兼槸灏忔暟锛屽垯鍏堝鍏惰繘琛屽洓
鑸嶄簲鍏ュ埌鏁存暟锛?/p>
鍐嶅
<
鏁板�艰〃杈惧紡
1>
杩涜鍥涜垗浜斿叆杩愮畻
3
銆佸嚱鏁拌兘澶?/p>
鎺ュ彈鐨勫皬鏁颁綅鏁版渶澶氫负
14
浣嶏紝
濡傛灉
<
鏁板�艰〃杈惧紡
2>
鐨勫�间负璐熷�硷紝绯荤粺灏?/p>
浣滃嚭閿欒鎻愮ず銆?/p>
Round(123.456, 1)=123.4
瀛楃鍑芥暟
鏍煎紡
鍚嶇О涓庡姛鑳?/p>
绀轰緥鍙婄粨鏋?/p>
InStr(String1,String2 )
瀛楃涓叉绱㈠嚱鏁?/p>
InStr("abcdABCD", "bc")=2