Randbetween- certain condtions??

**emily_brou** · 10-22-2015, 05:14 AM

I am struggling so much right now. I understand how to do the randbetween function and manipulate it in several ways- but i am stuck at this problem! the question is....

"Create a list of 25 random percentages such that one-fourth of them are between 26% and 74.7% and the rest are between 89% and 99% "

how would I go about doing randbetween under these specific conditons...?

the only formula i could come up with is =((RANDBETWEEN(26,74.7))*(3*(RANDBETWEEN(89,99))))/100

this returns a value in the 1000's which i know is not right and i know this is because I am multiplying the numbers but I have no idea what to do! Can anyone please help me?? Thank you so much

**Special-K** · 10-22-2015, 06:06 AM

Here's what I'd do, I assume I've read this correctly

25 random percentages, 1/4 of them are between 26%-74.7% and rest 89%-99%

in A1
=IF(ROW()<=25/4,RANDBETWEEN(260,747),RANDBETWEEN(890,990))/10
and copy down to A25

What I don't understand is given 25 percentages how you can get 1/4 of them (and that must mean EXACTLY a quarter) to be between a certain range since 25 /4 is not an integer. Maybe I've misinterpreted what it means.

Randbetween- certain condtions??

LinkBack

Thread Tools

Rate This Thread

Display

Randbetween- certain condtions??

Re: Randbetween- certain condtions??

Thread Information

Users Browsing this Thread

Similar Threads

Generate Random Time Series using RANDBETWEEN, but NOT with RANDBETWEEN in Each Cell

Average when condtions are met

Lookup with two condtions

Average with two condtions

IF Formula with 2 condtions in it...

[SOLVED] checking two condtions

[SOLVED] SUM IF 2 CONDTIONS

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions