EXCEL macro, plus even with less than 100 less.
[Users questions | Browse:87 | Favorites]
Users questions: Children to participate in abacus competition, the kinds of questions is 11-99 with less than the number of addition and subtraction. Please make a EXCEL macros. First, the automatic in B, C, D, E, F out of 15 random numbers generated, requiring 11 to 99, with 11 and 99, after a random number generator, if you do not run the macro again, the insurance Remain unchanged. Only run the macro again, only to re-generate a new random number. Second, the A2 to automatically generate a random A15 + or -. Column addition and subtraction with the result can not be negative, if negative, can only be set to +. + Or - after the election, if you do not run the macro again, remains unchanged. Only then Runs the macro, only to re-generate a new + or -. Line 18 produces a result of addition and subtraction of each column. Currently I set up a little simple functions, some more than 1 100, I was 11-99 less than .2 random number generator, do not change unless the change only run the macro again. 3A column addition and subtraction If randomly generated, and unless you run the macro again, or remain unchanged. 4 To ensure that every step of the operation of each column can not produce a negative result of the operation, the children never learned negative. Easy to use macro, intermediate operation is not considered a negative processes, such as 25-55 have a negative. The first grade students can not have Negative. Is able to take into account this factor. The other: as long as A (+ -) B (11-99) out on the line, in column C have step by step operation results, such as C2 is 25-55 = 30, B18 to produce the final results can be retained.
Experts answer: instructions, you just press a "generate data "Button, you can generate the data, and then finished after the title, then again, will generate new data Annex :11-99 even plus even less within the topic (1). Xls
Experts answer: instructions, you just press a "generate data "Button, you can generate the data, and then finished after the title, then again, will generate new data Annex :11-99 even plus even less within the topic (1). Xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.