If function is used to calculate the grade If function is used to calculate the grade. There are three grades: average score greater than or equal to 80 is "excellent"; average score greater than or equal to 65 is "good"; others are "average"

If function is used to calculate the grade If function is used to calculate the grade. There are three grades: average score greater than or equal to 80 is "excellent"; average score greater than or equal to 65 is "good"; others are "average"

Hello:
For example, if the average score is in column C and the calculated grade is in column D, enter the following formula in the cell of column D:
=If (D3 > = 80, "excellent", if (D3 > 65, "good", "average"))

In the spreadsheet, how to use the if function to screen out the four grades of excellent, medium and poor with scores? 90 points or more is excellent, 80-90 is good, 60-80 is medium

It's troublesome to use if. It's OK. It's recommended to use lookup ()
=Lookup (A1, {0,60,80,90100}, {poor, medium, good, excellent})
The if version is as follows
=If (A1 > = 90, "excellent", if (A1 > = 80, "good", if (A1 > = 60, "medium", "poor"))

Given that f (x) = 5 when x = 100, f (x) = 1 when x = 1000, f (x) = 0.2 when x = 10000, find f (x)

When x = 100, f (x) = 5, then f (10 ^ 2) = 5
When x = 1000, f (1000) = 1, that is, f (10 ^ 3) = 1
When x = 10000, f (10 ^ 4) = 0.2
That is, f (10 ^ 4) = f (10 ^ 3) / F (10 ^ 2)
From this we can deduce that f (x) = f (10 ^ (n-1)) / F (10 ^ / (n-2)) (x = 10 ^ n)

1 / 100 x 1 / 10 x = 1000,

On the right
25x/1500=1000
The solution is x = 60000