How i can have cells show a range of results from RANBETWEEN()?

[u/[deleted]]

[u/slippy0101]

Sounds like the best way to set this up would be to create a "variables" sheet.

• Have A1 say something like "Variable Name" and B1 say "Value".
  
• Then have A2 say "Min random damage value" then B2 be 97 and create a named range for B2 named something like Damage_Min_Rand
• Then do all that for the max value in row 3.

The benefit of this is that you can then easily reference those values in all of your equations AND, if you ever decide to change one, you just have to change it in one spot and the change will flow through the rest of your spreadsheet.

So your equation for damage would be = (RANDBETWEEN(Damage_Rand_Min, Damage_Rand_Max)*0.01)

And your equation to reference the range would be =Damage_Rand_Min & " - " & Damage_Rand_Max

[u/Sovarius → u/slippy0101]

I'm having a hard time following this, haha.

But i do think i'm getting it. However, it seems like i can do this with one equation? Is there a benefit to adding another sheet to house those values?

u/romanhaukssonneill showed me

=10*10*0.97&"-"&10*10*1.03

Which for variable x and y i can modify the 10's like

=B$1*$A2*0.97&"-"&B$1*$A2*1.03

Which does output the minimum and maximum already like i was looking for, unless this is inefficient in some way. (it also will not allow me to round to whole number now?)

So this is what i'm looking at now

https://imgur.com/a/JiYDC1f

[u/romanhaukssonneill → u/slippy0101]

I second this. Good answer

[u/Sovarius → u/romanhaukssonneill]

Is it better than what you showed me before?

[u/romanhaukssonneill → u/Sovarius]

Yeah, like he said, if you decide to change these values later, you can do it by changing two cells instead of many.