Forum Discussion
Randbetween with fixed sum in a flexible formula
Heej there I do definitely need some help..
I am trying to make a Randbetween function with a fixed sum, there is very little info about it on the internet and the solutions that actually are on the internet won't work when using them in a flexible way (adjusting low, high, N, etc.). Can somebody help me with this?
Something like the attached perhaps?
Thanks a lot for your reply, it's something like that, but it always has to be correct. There should be 0 tolerance for getting numbers exceeding the boundaries. Any ideas for this?
That can only be achieved with a small macro, see attached.
