Randbetween with fixed sum in a flexible formula

Copper Contributor

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?

3 Replies

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.