How to realize arbitrary temperature in excel?

Record the temperature and humidity: For example, the temperature is in cell A 1. Such as: 23

Temperature and humidity change regularly with the seasons. Also pay attention to the weather.

=IF(B2= "Yin", RANDBETWEEN(5, 13), IF(B2= "snow", RANDBETWEEN(- 1, 2), 20))

=IF(B2= "Yin", rand between (50, 130), IF(B2= "snow", rand between (- 10, 20), 200))/ 10.

Enter in B 1 &: = "temperature =" ina1&; "℃"

If a random number is used, enter =ROUND(20+5*RAND (), 0) in B2.

Extended data:

For example, the number 2 10 and the text "quarterly income" are constants. Neither the expression nor the value produced by the expression is a constant. )。

The following is a simple calculation to illustrate the structure of the formula.

= average (A9: D 17)*E 1+50.

This formula is the result of multiplying the average cell area of "A9: D 17" by the value represented by "E 1" and adding 50.

Function: "AVERAGE ()" is a function to calculate the average value.

References: "A9: D 17" and "E 1" are cell references.

Operators: "*",: "-"and "+"are operators.

Constant: "50" is a constant in this example.

For example, the summation operation uses a faster summation formula:

SUM= cell+cell is faster. You don't need to enter numbers, just hold down the mouse and drag.

Baidu Encyclopedia -EXCEL Formula