Excel - sequence with a random number

[beng986]

Hi,

I have some set values (columns A:B, rows 1:4)

Months	10
High	150
Low	10
Set or Random	Set

I have used the sequence function to generate a row of values:

=SEQUENCE(1,B1,1,1)

If B4 is equal to set I can use the formula below:
=IF(B4="Set",SEQUENCE(1,B1,AVERAGE(B2:B3),0))

However if B4 is set to random, how would I do the same thing but set each number to random but keeping within the high and low range?

 

[Fluff]

How about
=IF(B4="Set",SEQUENCE(1,B1,AVERAGE(B2:B3),0),IF(B4="Random",RANDARRAY(1,B1,B3,B2,1)))

 

[beng986]

How about
=IF(B4="Set",SEQUENCE(1,B1,AVERAGE(B2:B3),0),IF(B4="Random",RANDARRAY(1,B1,B3,B2,1)))

Thanks.

 

[Fluff]

You're welcome