Difficult Excel exercise

**sarisman** · 06-14-2008, 07:53 AM

I Have the following exercise (was in swedish tried to translate it to english)

6. When we run the following program we get 5 Random numbers 0,4567, 0,3212, 0,6318, 0,4234 and 0,1673. Whats the print-out in this case ?

Please Login or Register  to view this content.

And a second question is how can we write an intervall of a with other words
-300<a<300 so that we get a random number but not the 0 !
I wrote =100*(INT(RAND()7-3) and i get -300,-200,-100,0,100,200,300 but as I said the exercise asks for all the numbers that i wrote except the 0 ! Its imposible !

**mudraker** · 06-14-2008, 08:00 AM

sarisman

Welcome to Exceltip forum

Please take a couple of minutes and read the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) and wrap your VBA code (Rule 3)

**Simon Lloyd** · 06-14-2008, 09:51 AM

Sarisman, we cannot help directly with homework or assignments, we can give advice or steer you in the right direction but we cannot provide a solution!

**daddylonglegs** · 06-14-2008, 10:02 AM

For your second question......

You could use a formula that would generate a random number 1 to 300 and then multiply by a randomly generated 1 or -1......

**sarisman** · 06-14-2008, 12:08 PM

Ok guys thanks for your replies ! Well I dont want the solution but to guide me to the right way and find the solution by myself. For example as I can understand on my first question if I change a to a = Int(0,6318*10+1) I get 7 which is the whole number of 0,6318 and so on.... Is that right do I have to do something else ?