Excel 2013 Formula Error

[okanarslan20]

Hi guys, I use that formula

[COLOR=#333333]=RANDBETWEEN([/COLOR][COLOR=Blue]MAX([COLOR=Red]$B$2,$A$2-([COLOR=Green]([COLOR=Purple]$D$2-ROWS([COLOR=Teal]$A$4:$A4[/COLOR])[/COLOR])*$C$2[/COLOR])[/COLOR]),MIN([COLOR=Red]$C$2,$A$2-([COLOR=Green]([COLOR=Purple]$D$2-ROWS([COLOR=Teal]$A$4:$A4[/COLOR])[/COLOR])*$B$2[/COLOR])[/COLOR])[/COLOR][COLOR=#333333])[/COLOR]

But i get some error like that. I can not solve this problem :/

 

[okanarslan20]

I use Excel 2013 and I convert formulas to Turkish language.

 

[thisoldman]

Is your MAX greater than your MIN? RANDBETWEEN requires that the first value be smaller or equal to the second value.

Good: =RANDBETWEEN(0, 100)

#NUM ! Error: =RANDBETWEEN(100, 0)

 

[okanarslan20]

Is your MAX greater than your MIN? RANDBETWEEN requires that the first value be smaller or equal to the second value.

Good: =RANDBETWEEN(0, 100)

#NUM ! Error: =RANDBETWEEN(100, 0)

Now I got #NUMBER ? error

 

[okanarslan20]

Is your MAX greater than your MIN? RANDBETWEEN requires that the first value be smaller or equal to the second value.

Good: =RANDBETWEEN(0, 100)

#NUM ! Error: =RANDBETWEEN(100, 0)

I use that :

=RASTGELEARADA(MİN($C$2;$A$2-(($D$2-SATIRSAY($A$4:$A4))*$B$2));MAK($B$2;$A$2-(($D$2-SATIRSAY($A$4:$A4))*$C$2)))

and I got #NUMBER ? error

 

[thisoldman]

What is the value of
=MİN($C$2;$A$2-(($D$2-SATIRSAY($A$4:$A4))*$B$2))

What is the value of
=MAK($B$2;$A$2-(($D$2-SATIRSAY($A$4:$A4))*$C$2))

SATIRSAY, in English, is ROWS; MAK is MAX.

When you get the error, what are the values in A2, B2, C2, and D2?

 

[okanarslan20]

What is the value of
=MİN($C$2;$A$2-(($D$2-SATIRSAY($A$4:$A4))*$B$2))

What is the value of
=MAK($B$2;$A$2-(($D$2-SATIRSAY($A$4:$A4))*$C$2))

SATIRSAY, in English, is ROWS; MAK is MAX.

When you get the error, what are the values in A2, B2, C2, and D2?

I need 20 random numbers between 0-5. But there are only two numbers I use that formulas

A4:

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="align: left"]=RANDBETWEEN([COLOR=Blue]MAX([COLOR=Red]$B$2,$A$2-([COLOR=Green]([COLOR=Purple]$D$2-ROWS([COLOR=Teal]$A$4:$A4[/COLOR])[/COLOR])*$C$2[/COLOR])[/COLOR]),MIN([COLOR=Red]$C$2,$A$2-([COLOR=Green]([COLOR=Purple]$D$2-ROWS([COLOR=Teal]$A$4:$A4[/COLOR])[/COLOR])*$B$2[/COLOR])[/COLOR])[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]

A5:

[COLOR=#333333]=IF([/COLOR][COLOR=Blue]ROW()=$D$2+3,$A$2-SUM([COLOR=Red]$A$4:$A4[/COLOR]),IF([COLOR=Red]ROW()>$D$2+3,"",RANDBETWEEN([COLOR=Green]MAX([COLOR=Purple]$B$2,$A$2-([COLOR=Teal]SUM([COLOR=#FF00FF]$A$4:$A4[/COLOR])+([COLOR=#FF00FF]$D$2-ROWS([COLOR=Navy]$A$4:$A5[/COLOR])[/COLOR])*$C$2[/COLOR])[/COLOR]),MIN([COLOR=Purple]$C$2,$A$2-([COLOR=Teal]SUM([COLOR=#FF00FF]$A$4:$A4[/COLOR])+([COLOR=#FF00FF]$D$2-ROWS([COLOR=Navy]$A$4:$A5[/COLOR])[/COLOR])*$B$2[/COLOR])[/COLOR])[/COLOR])[/COLOR])[/COLOR][COLOR=#333333])[/COLOR]

B4:

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="align: left"]=IF([COLOR=Blue]OR([COLOR=Red]$C$2*D$2<$A$2,$B$2*$D$2>$A$2[/COLOR]),"Can't be done!",""[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]

B10:

[COLOR=#333333]=SUM([/COLOR][COLOR=Blue]A4:A20[/COLOR][COLOR=#333333])
[/COLOR]

 

[thisoldman]

Does this help?

To get a random number between 0 and 5:
=5 * RAND()

Random integers between 0 and 5:
=ROUND(5 * RAND(), 0)
=YUVARLA(5 * RAND(), 0)
[0, 1, 2, 3, 4, or 5]

Or, with two numbers to the right of the decimal point:
=ROUND(5 * RAND(), 2)
=YUVARLA(5 * RAND(), 2)
Example returns 1.77, 0.12, 1.26, 4.88, and 3.11 for five trials.

 

[okanarslan20]

Does this help?

To get a random number between 0 and 5:
=5 * RAND()

Random integers between 0 and 5:
=ROUND(5 * RAND(), 0)
=YUVARLA(5 * RAND(), 0)
[0, 1, 2, 3, 4, or 5]

Or, with two numbers to the right of the decimal point:
=ROUND(5 * RAND(), 2)
=YUVARLA(5 * RAND(), 2)
Example returns 1.77, 0.12, 1.26, 4.88, and 3.11 for five trials.

Thank you! Problem solved

 

[thisoldman]

You are welcome. I'm happy to be able to help.