EXCEL FUNCTION USAGE ISSUES

Since you want to make the number different every day, and you want to distribute the total amount you get unevenly, you can use the method of random numbering.

Condition: Assuming column A from A1 to A31 is the number of days in the month, and the corresponding cell in column B is the turnover of that day, then enter the total amount you get for the month in B32. With these two assumptions, we can calculate the random number based on column c.

Here's how:1Enter "=rand()" in c1 without quotation marks), which is a function that takes numbers randomly.

2.Copy c1

3.Select all cells in column C from C2 to C31, press Ctrl plus V, and copy the contents of C1 to these cells.

4.Enter "=sum(c1:c31)" in c32 (without quotation marks) to find the sum of c1 to c31.

5.Enter "=c1 c$32*b$32" in b1 (without quotation marks), and be sure to add the $ symbol.

6.Copy B1 and paste into all column B cells from B2 to B31.

7.Enter the turnover you get in B32 and you get a different turnover from B1 to B31 every day.

Remarks:1Because the rand function is any number between 0 and 1, so every change in any cell will change the number of turnover you get, so it is recommended to make a draft of only the above parts, after getting the turnover, copy the result, in the excel sheet you need to paste, right-click, and select the "value" in the "special paste" below the paste.

2.Because rand is a number from 0 to 1, if you feel that the number of turnover needs to be different, you can enter +10, or *100 and so on after a certain "=rand()", such as "=rand()+4", "=rand()*23", which can ensure that there is a large difference between your daily turnover, especially during holidays.

Well, I've worked so hard to write. Hope it helps.

Select the cell, click the insert function drop-down box, select "Finance" in the selection category, look for it inside, there is a vdb function, it may meet your requirements, you try it.

Does the landlord do random assignments? If yes, try my method.

Start by generating a column of random numbers: enter =rand() in a2, fill to a32, enter =sum(a2:a32) in a33, enter your total in b33, enter =a2 a$33*b$33 in b2, fill to b32, okay, now the data is random every day, and even it changes every time you save it.

To fix the numbers, select column b, copy, then right-click on b, paste the numeric value.

I don't understand, what does it mean to divide this total into 31 days without equalizing it? Do you want to say that this total is divided into 31 parts, and each part is different?

I don't know if I'm right, you see.