InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : A simple Excel spreadsheet (without Marcos) than can predict 3-digit Numbers? |
|
Answer» I am looking for a simple Excel spreadsheet (no Marcos) than when You Enter past 3-digit Numbers can generate 5 new 3-digit numbers. Like for example 159 was drawn and use that NUMBER (159) to come up with 5 new (3-digit numbers). So it would be based on past number or a few past numbers. You can use formulas in the other five cells. By using the value typed into the original cell you can generate values for the other five cells. So it would be based on past number or a few past numbers. You could KEEP a history of past numbers EITHER on another worksheet or in hidden cells on the main worksheet. Keep in mind that past performance is no guarantee of future results. That is Great, but what are the formulas in the other 5 cells for the value typed in the original cell?I can't really give you any specific formulas, but I can show you the mechanics of setting this up: Assume cell A1 is where the 3 digit number is entered. In cell D4 you could put the formula =(A1*3); in cell E7 you could put the formula =(A1^2); repeat, using other formulas in any other 3 cells. As soon as the 3 digit number is entered in A1, the other cells will recalculate based on the A1 value. Of COURSE it will be your job to come up with formulas that guarantee all the results will be 3 digit numbers. Good luck. Just curious, but why no macros? |
|