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