Function myRANDBETWEEN (lo As Double, hi As Double) As Double

myRANDBETWEEN = Evaluate(“randbetween(“ & lo & “,” & hi & “)“)

This is in VBA I guess?

I need a similar thing in javascript.

Problem: I want to make random numbers but stupid google sheets and excel both use volatile randbetween() functions. One way to get around this is to embed the randbetween in a custom function. If I were using excel the above would work as custom scripts in excel are based on VBA. However, I’m using Google sheets for Run Club and so need to use javascript to perform a similar function. If anyone can help me I’ll give them a hug. Save me raptor jesus, you’re my only hope.

Advertisement