一些常见的Excel公式英文例句和中文翻译:
SUM: Adds up a range of numbers
AVERAGE: Calculates the average value of a range of numbers
MAX: Returns the highest value in a range of numbers
MIN: Returns the lowest value in a range of numbers
IF: Tests a condition and returns one value if the condition is met and another value if the condition is not met.
例:=SUM(A1:A5) -- 对A1到A5的数字求和
=AVERAGE(A1:A5) -- 求A1到A5的平均值
=MAX(A1:A5) -- 求A1到A5的最大值
=MIN(A1:A5) -- 求A1到A5的最小值
=IF(A1>10, "Greater than 10", "Less than 10") -- 如果A1>10,返回"Greater than 10",否则返回"Less than 10"

扫码进群(如群满请谅解)
长按或截屏保存,再用微信扫一扫
最佳回答 2023-07-10