徐梓寧EXCEL名稱方塊,AND,OR,COUNT,COUNTIF,INDIRECT間接定址 

#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	25	FALSE	FALSE		
#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	29	FALSE	FALSE		
										
6	3	6	4	0	32	118	0	3	買權賣權	
COUNT統計有幾個數字 					範圍	S1:Y506		=COUNTIF(X508))	3	TRUE
	買的權利 		認購的權利			0	=COUNT(X508)		501	FALSE
	期貨交易所交易			證卷交易所交易			=COUNT(INDIRECT(X508))

留言

  1. Gail Tai2026年11月12日 下午3:55

    商業軟體期中考，必須訂正，要呈現正確資訊。https://tzuning-hsu.blogspot.com/2026/11/excelformulas.html
    計算機。https://tzuning-hsu.blogspot.com/2026/11/htmlcssjavascrip.html
    程式設計期中考。https://tzuning-hsu.blogspot.com/2026/11/htmlcssjavascriptpython.html
    https://tzuning-hsu.blogspot.com/2026/10/pythoninputfind-1.html
    https://tzuning-hsu.blogspot.com/2026/10/pythonsetdict372411251.html
    https://tzuning-hsu.blogspot.com/2026/10/excelandorcountcountifindirect.html

    回覆刪除

張貼留言

這個網誌中的熱門文章

徐梓寧python輸入input尋找find沒找到-1

file = open('金融常識.txt','r',encoding='utf-8') lines = file.readlines() file.close() x = input('徐梓寧輸入搜尋關鍵詞: ') for line in lines: if line.find(x) != -1: print(line) file = open('金融常識.txt','r',encoding='utf-8') lines = file.readlines() file.close() x = input('徐梓寧輸入搜尋關鍵詞: ') n=0 for line in lines: if line.find(x) != -1: n=n+1 print(n,'',line,end='') print('總共{n}題') file = open('金融常識.txt','r',encoding='utf-8') lines = file.readlines() file.close() x = input('徐梓寧輸入搜尋關鍵詞: ') n=0 for line in lines: if x in line: n=n+1 print(n,'',line,end='') print('總共{n}題') file = open('金融常識.txt','r',encoding='utf-8') reading = file.read() file.seek(0) #回到檔案的開始 lines = file.readlines() file.close() print('read()方法讀共', len(reading), 'readlines()方法讀共', len(lines)) x = input('劉任昌輸入搜尋關鍵詞: ') n = 0 fo...
閱讀完整內容