Output 0 to 100

[Guest]

Hi All,

Is there any formula which return the value 0 to 100 only?

Thanks & Regards

Hassan

 

[Thomas Ramel]

Grüezi

Hassan wrote at 11.08.2007

Is there any formula which return the value 0 to 100 only?

If you like an random value in between these ranges you can try the
following:

=TRUNC(RAND()*100,0)



Mit freundlichen Grüssen
Thomas Ramel

 

[Guest]

=RANDBETWEEN(0,100)

.... but you'll need to load the Analysis Toolpack Add-In

 

[Dallman Ross]

Hassan wrote at 11.08.2007


If you like an random value in between these ranges you can try
the following:

=TRUNC(RAND()*100,0)

Easier:

=MOD(somenumber,100)

 

[Thomas Ramel]

Grüezi Dallman

Dallman Ross schrieb am 12.08.2007

Easier:

=MOD(somenumber,100)

....and how you make 'somenumber' random and without decimals...?


Mit freundlichen Grüssen
Thomas Ramel

 

[Dallman Ross]

Grüezi Dallman

Bist Du aus der Schweiz?

Dallman Ross schrieb am 12.08.2007


...and how you make 'somenumber' random and without decimals...?

I wasn't addressing the "random" idea, which you proposed but
which the OP has not confirmed to be his wish. I was merely
going to the OP's original question of supplying a formula that
will return only that range of values. Yes, for a requirment
for random data, your answer is of course very good.

=dman=

 

[Thomas Ramel]

Grüezi Dallman

Dallman Ross schrieb am 15.08.2007

Bist Du aus der Schweiz?

Ja, bin ich - hört man das *so* gut?

I wasn't addressing the "random" idea, which you proposed but
which the OP has not confirmed to be his wish. I was merely
going to the OP's original question of supplying a formula that
will return only that range of values. Yes, for a requirment
for random data, your answer is of course very good.

OK, I understand your point of view - interesting, in deed.

So now we wait until the OP will decide.


Mit freundlichen Grüssen
Thomas Ramel

 

[Dallman Ross]

Grüezi Dallman

Dallman Ross schrieb am 15.08.2007


Ja, bin ich - hört man das *so* gut?

Häsche dini Ovo hüüt scho' g'haaa?

I wasn't addressing the "random" idea, which you proposed but
which the OP has not confirmed to be his wish. [. . .]

OK, I understand your point of view - interesting, in deed.

So now we wait until the OP will decide.

Okay, I'm as curious as you are.

=dman=