Automatic generation of second grade stochastic arithmetic system

The main formula is: VLOOKUP, Randbetween

The 1.VLOOKUP function is a portrait lookup function in Excel.

Function: Search by column, and finally return the value corresponding to the column order of the query;

How to use: VLOOKUP (the value to find, the area to find, the number of columns in the lookup area to return data, fuzzy match/Exact match (true/false or not))

The 2.RANDBETWEEN function returns a random integer that is between two specified numbers. A new random integer is returned each time the worksheet is calculated.

How to use:

Randbetween (bottom,top) Bottom parameter: The smallest integer that Randbetween will return. Top parameter: Randbetween The largest integer that will be returned. So at this point =vlookup (Randbetween (1,4), u1:v4,2) here means to randomly extract an integer from the U1 to the V4 area of 1-4 to extract the corresponding arithmetic symbol. =randbetween (1,99) randomly selects integers between 1-99. But if we pull down at this point, we'll find that there is an error.

Click to find the wrong cell in the drop-down process, the selection changes.

So, at this point, you need to apply the lock symbol $ lock cell

Problem solving, load adjust cell format, get the final result.

Automatic generation of second grade stochastic arithmetic system