林政宏w3schools.com/excel/excel_functions.php

 w3schools.com/excel/excel_functions.php

Function	Description
=AND	Returns TRUE or FALSE based on two or more conditions
=AVERAGE	Calculates the average (arithmetic mean)
=AVERAGEIF	Calculates the average of a range based on a TRUE or FALSE condition
=AVERAGEIFS	Calculates the average of a range based on one or more TRUE/FALSE conditions
=CONCAT	Links together the content of multiple cells
=COUNT	Counts cells with numbers in a range
=COUNTA	Counts all cells in a range that has values, both numbers and letters
=COUNTBLANK	Counts blank cells in a range
=COUNTIF	Counts cells as specified
=COUNTIFS	Counts cells in a range based on one or more TRUE or FALSE condition
=IF	Returns values based on a TRUE or FALSE condition
=IFS	Returns values based on one or more TRUE or FALSE conditions
=LEFT	Returns values from the left side of a cell
=LOWER	Reformats content to lowercase
=MAX	Returns the highest value in a range
=MEDIAN	Returns the middle value in the data
=MIN	Returns the lowest value in a range
=MODE	Finds the number seen most times. The function always returns a single number
=NPV	The NPV function is used to calculate the Net Present Value (NPV)
=OR	Returns TRUE or FALSE based on two or more conditions
=RAND	Generates a random number
=RIGHT	Returns values from the right side of a cell
=STDEV.P	Calculates the Standard Deviation (Std) for the entire population
=STDEV.S	Calculates the Standard Deviation (Std) for a sample
=SUM	Adds together numbers in a range
=SUMIF	Calculates the sum of values in a range based on a TRUE or FALSE condition
=SUMIFS	Calculates the sum of a range based on one or more TRUE or FALSE condition
=TRIM	Removes irregular spacing, leaving one space between each value
=VLOOKUP	Allows vertical searches for values in a table
=XOR	Returns TRUE or FALSE based on two or more conditions

留言

  1. George2026年6月28日 晚上11:37

    623.concatenate.https://fake888.blogspot.com/2026/06/concatenateexcel_01429173572.html
    https://fake888.blogspot.com/2026/06/excelleftmidrightlenfindunicodeunichar.html
    623補COLAB但產生的網頁不能執行。https://fake888.blogspot.com/2026/06/colabpython.html
    623補spyder.https://fake888.blogspot.com/2026/06/pythonhtml-css-javascript.html
    seo和計算機。https://fake888.blogspot.com/2026/06/ai-seo.html
    623計算機.https://fake888.blogspot.com/2026/06/javascriptone-page.html
    623函數excel.https://fake888.blogspot.com/2026/06/w3schoolscomexcelexcelfunctionsphp.html

    回覆刪除

張貼留言

這個網誌中的熱門文章

林政宏輸入tkinter繪圖模組金融常識測驗APP

import tkinter #輸入tkinter繪圖模組 #財金程式設計602 class Financial: #類別用於建構504道金融常識題目 def __init__(self, number, q, a, b, c, d, ans): self.number, self.q, self.ans = number, q, ans self.a, self.b, self.c, self.d = a, b, c, d def check(choice): choice = reply.get() #以字串存'1'...'4' temp = number.get() - 1 #題號 if choice == '1': LBa.config(bg="#a4abc1") if choice == List[temp].ans: LBa.config(bg='blue',fg='white') if choice == '2': LBb.config(bg="#a4abc1") if choice == List[temp].ans: LBb.config(bg='blue',fg='white') if choice == '3': LBc.config(bg="#a4abc1") if choice == List[temp].ans: LBc.config(bg='blue',fg='white') if choice == '4': LBd.config(bg="#a4abc1") if choice == List[temp].ans: LBd.config(bg=...
閱讀完整內容

林政宏VSCODE編輯font

圖片
import tkinter #輸入tkinter繪圖模組 #財金程式設計602 class Financial: #類別用於建構504道金融常識題目 def __init__(self, number, q, a, b, c, d, ans): self.number, self.q, self.ans = number, q, ans self.a, self.b, self.c, self.d = a, b, c, d def check(choice): choice = reply.get() #以字串存'1'...'4' temp = number.get() - 1 #題號 if choice == '1': LBa.config(bg="#a4abc1") if choice == List[temp].ans: LBa.config(bg='blue',fg='white') if choice == '2': LBb.config(bg="#a4abc1") if choice == List[temp].ans: LBb.config(bg='blue',fg='white') if choice == '3': LBc.config(bg="#a4abc1") if choice == List[temp].ans: LBc.config(bg='blue',fg='white') if choice == '4': LBd.config(bg="#a4abc1") if choice == List[temp].ans: LBd.config(bg=...
閱讀完整內容

林政宏期末考為PYTHON貪吃蛇增加速度

圖片
from tkinter import * import random GAME_WIDTH,GAME_HEIGHT = 800, 400 SPEED = 600 #時間單位千分之一 SPACE_SIZE, BODY_PARTS= 50, 3 #左邊變數 assigning value SNAKE_COLOR = ["red","orange","yellow","green","blue","indigo", "purple"] FOOD_COLOR = "white" BACKGROUND_COLOR = "black" class Snake: def __init__(self): self.body_size = BODY_PARTS self.coordinates = [] self.squares = [] for i in range(0, BODY_PARTS): self.coordinates.append([0, 0]) for x, y in self.coordinates: i = random.randint(0,6) square = canvas.create_rectangle(x, y, x + SPACE_SIZE, y + SPACE_SIZE, fill=SNAKE_COLOR[i], tag="snake", width=20,outline='blue') self.squares.append(square) class Food: def __init__(self): x = random.randint(0, int(GAME_WIDTH / SPACE_SIZE)-1) * SPACE_SIZE y = random.randint(0, int(GAME_HE...
閱讀完整內容