Hi All,

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

Thanks & Regards

Hassan

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

--
- MVP für Microsoft-Excel -
[Win XP Pro SP-2 / xl2003 SP-2]
Microsoft Excel - Die ExpertenTipps

In , Thomas Ramel
spake thusly:

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)

Easier:

=MOD(somenumber,100)

--
=dman=

Grüezi Dallman

Dallman Ross schrieb am 12.08.2007

In , Thomas Ramel

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)

Easier:

=MOD(somenumber,100)

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


Mit freundlichen Grüssen
Thomas Ramel

--
- MVP für Microsoft-Excel -
[Win XP Pro SP-2 / xl2003 SP-2]
Microsoft Excel - Die ExpertenTipps

In , Thomas Ramel
spake thusly:

Grüezi Dallman

Bist Du aus der Schweiz?

Dallman Ross schrieb am 12.08.2007

In , Thomas Ramel

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)

Easier:

=MOD(somenumber,100)

...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=

Grüezi Dallman

Dallman Ross schrieb am 15.08.2007

In , Thomas Ramel

Grüezi Dallman

Bist Du aus der Schweiz?

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

Dallman Ross schrieb am 12.08.2007

In , Thomas Ramel

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)

Easier:

=MOD(somenumber,100)

...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.

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

--
- MVP für Microsoft-Excel -
[Win XP Pro SP-2 / xl2003 SP-2]
Microsoft Excel - Die ExpertenTipps

=RANDBETWEEN(0,100)

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


--
Hope that helps.

Vergel Adriano


"Hassan" wrote:

Hi All,

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

Thanks & Regards

Hassan