RMB 1200.00
RMB 2135.00
RMB 4896.00
RMB 15930.00
RMB 9140.00
RMB 14916.00
RMB 11952.00
RMB 5720.00
RMB 375.00
RMB 4440.00
In the EXCEL spreadsheet, I want to ask how to make the automatically assigned I add up these figures, let them not greater than or equal to 11700 to 11700, is a great god thanks everyone
CodePudding user response:
A great god if you can add my qq, QQ67816320CodePudding user response:
375.00 375.00500.00 500.00
875.00 375.00 + 500.00
1200.00 1200.00
1575.00 375.00 + 1200.00
1700.00 500.00 + 1200.00
2075.00 375.00 + 500.00 + 1200.00
2135.00 2135.00
2510.00 375.00 + 2135.00
2635.00 500.00 + 2135.00
3010.00 375.00 + 500.00 + 2135.00
3335.00 1200.00 + 2135.00
3710.00 375.00 + 1200.00 + 2135.00
3835.00 500.00 + 1200.00 + 2135.00
4210.00 375.00 + 500.00 + 1200.00 + 2135.00
4440.00 4440.00
4815.00 375.00 + 4440.00
4896.00 4896.00
4940.00 500.00 + 4440.00
5271.00 375.00 + 4896.00
5315.00 375.00 + 500.00 + 4440.00
5396.00 500.00 + 4896.00
5640.00 1200.00 + 4440.00
5720.00 5720.00
5771.00 375.00 + 500.00 + 4896.00
6015.00 375.00 + 1200.00 + 4440.00
6095.00 375.00 + 5720.00
6096.00 1200.00 + 4896.00
6140.00 500.00 + 1200.00 + 4440.00
6220.00 500.00 + 5720.00
6471.00 375.00 + 1200.00 + 4896.00
6515.00 375.00 + 500.00 + 1200.00 + 4440.00
6575.00 2135.00 + 4440.00
6595.00 375.00 + 500.00 + 5720.00
6596.00 500.00 + 1200.00 + 4896.00
6920.00 1200.00 + 5720.00
6950.00 375.00 + 2135.00 + 4440.00
6971.00 375.00 + 500.00 + 1200.00 + 4896.00
7031.00 2135.00 + 4896.00
7075.00 500.00 + 2135.00 + 4440.00
7295.00 375.00 + 1200.00 + 5720.00
7406.00 375.00 + 2135.00 + 4896.00
7420.00 500.00 + 1200.00 + 5720.00
7450.00 375.00 + 500.00 + 2135.00 + 4440.00
7531.00 500.00 + 2135.00 + 4896.00
7775.00 1200.00 + 2135.00 + 4440.00
7795.00 375.00 + 500.00 + 1200.00 + 5720.00
7855.00 2135.00 + 5720.00
7906.00 375.00 + 500.00 + 2135.00 + 4896.00
8150.00 375.00 + 1200.00 + 2135.00 + 4440.00
8230.00 375.00 + 2135.00 + 5720.00
8231.00 1200.00 + 2135.00 + 4896.00
8275.00 500.00 + 1200.00 + 2135.00 + 4440.00
8355.00 500.00 + 2135.00 + 5720.00
8606.00 375.00 + 1200.00 + 2135.00 + 4896.00
8650.00 375.00 + 500.00 + 1200.00 + 2135.00 + 4440.00
8730.00 375.00 + 500.00 + 2135.00 + 5720.00
8731.00 500.00 + 1200.00 + 2135.00 + 4896.00
9055.00 1200.00 + 2135.00 + 5720.00
9106.00 375.00 + 500.00 + 1200.00 + 2135.00 + 4896.00
9140.00 9140.00
9336.00 4440.00 + 4896.00
9430.00 375.00 + 1200.00 + 2135.00 + 5720.00
9515.00 375.00 + 9140.00
9555.00 500.00 + 1200.00 + 2135.00 + 5720.00
9640.00 500.00 + 9140.00
9711.00 375.00 + 4440.00 + 4896.00
9836.00 500.00 + 4440.00 + 4896.00
9930.00 375.00 + 500.00 + 1200.00 + 2135.00 + 5720.00
10015.00 375.00 + 500.00 + 9140.00
10160.00 4440.00 + 5720.00
10211.00 375.00 + 500.00 + 4440.00 + 4896.00
10340.00 1200.00 + 9140.00
10535.00 375.00 + 4440.00 + 5720.00
10536.00 1200.00 + 4440.00 + 4896.00
10616.00 4896.00 + 5720.00
10660.00 500.00 + 4440.00 + 5720.00
10715.00 375.00 + 1200.00 + 9140.00
10840.00 500.00 + 1200.00 + 9140.00
10911.00 375.00 + 1200.00 + 4440.00 + 4896.00
10991.00 375.00 + 4896.00 + 5720.00
11035.00 375.00 + 500.00 + 4440.00 + 5720.00
11036.00 500.00 + 1200.00 + 4440.00 + 4896.00
11116.00 500.00 + 4896.00 + 5720.00
11215.00 375.00 + 500.00 + 1200.00 + 9140.00
11275.00 2135.00 + 9140.00
11360.00 1200.00 + 4440.00 + 5720.00
11411.00 375.00 + 500.00 + 1200.00 + 4440.00 + 4896.00
11471.00 2135.00 + 4440.00 + 4896.00
11491.00 375.00 + 500.00 + 4896.00 + 5720.00
11650.00 375.00 + 2135.00 + 9140.00
CodePudding user response:
This is format conversion problemIn my memory, no ready-made yuan in excel format processing
So will you first accounting data, converted to character CSTR ()
Whether the first symbol is RMB; If yes, will be the first character to delete
Then strings that will be processed and converted to a digital precision (single), in pay attention to the format of the digital format (accounting)
Then add and subtract
Finally, put RMB symbols add
If you have any RMB digital processing, excel + vba that don't have to bother