Excel formula in English is referred to as a "Excel function". It comes from Microsoft Excel, a spreadsheet application that is widely used for data analysis, organization and calculation.

一些常见的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