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 ...
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.