Forum Discussion

Sgeffert22's avatar
Sgeffert22
Copper Contributor
Oct 28, 2022

RandArray

I'm trying to make the total of my RandArray set equal a pre-determined total. Is there a way that this can even be done? 
excel
Formulas and Functions
Sgeffert22's avatar
Sgeffert22
Copper Contributor
Oct 28, 2022

HansVogelaar 

 

Thank you so much! Would I be able to add a range to this set as well? 

  • Sgeffert22's avatar
    Sgeffert22
    Copper Contributor
    Oct 28, 2022
    HansVogelaar

    Create a random number generator with 125 values, a range of 1.1-2.1, where the sum of those numbers equal 245
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 28, 2022

      Sgeffert22 

      That would be

       

      =LET(a, RANDARRAY(125, , 1.1, 2.1), s, SUM(a), a/s*245)

      • Sgeffert22's avatar
        Sgeffert22
        Copper Contributor
        Oct 28, 2022
        HansVogelaar
        Some of the values are over the max of 2.1, is there anyway to fix that?

Resources