In this Microsoft Excel video tutorial I explain how to create a series of random numbers that sum up to a specific value. For example 10 random numbers that sum up to 100. #exceltutorial #exceltips
Пікірлер: 17
@mahdihajiamiri688810 ай бұрын
You save my life I really appreciate this video.
@lanhtrungkien8862 ай бұрын
Thank you for your work!!! It have solved my problem
@jerrymiles7804 Жыл бұрын
Outstanding dear Mr. Chester! Best regards from Limón, Costa Rica!
@davidsyes5970 Жыл бұрын
It could be useful for anyone prototyping headcount for shifts that have to cover for anticipated crowd sizes. (When I do randomizations like that, I also ad control ranges to enable rapid up/downsizing of test values.) Or, suppose you want to randomize sales based on weather, temp, a given holiday, popularity of events, and by ice cream flavor. Or, suppose you want to simulate depletion of inventory. You could randomize numbers of customer purchases, unit counts, dollar amounts, taxes, and more, all to test viability of a biz model in mind for given prices, sizes, and lease durations of real estate. So, you could potentially wow a lender by showing you've got a well-defined randomized model of break even points. If you deeply build the model, it might make some bankers shut up and lend the money. (In my case, in 2002, when I randomized numbers in a biz model for a coffee shop plan, 2 bankers tried to avoid returning my biz plan (paper version, but, on my laptop, I showed the digital version. It was in Lotus 1-2-3), but I got back my copies since they refused to fund me because I refused to let them have first place on my home mortgage, which was at 5.95 APR (I'm a veteran), and commercial rates were over 7 to 8.5 %.)
@sudhirgouti543128 күн бұрын
Thanks
@Lokeshgowda20235 ай бұрын
Superb 🎉🎉🎉
@nanabeezil3617Ай бұрын
how many lines of 4 numbers sum up to 50,please i need the answer
@mymatemartin Жыл бұрын
That's pretty clever but how would it be used in business??
@edikind334711 күн бұрын
But what if I only want integers?
@deanmartin62224 ай бұрын
How about if the adjusted cells should be in a specified ranged values?
@andy60768 ай бұрын
What can I do if I need to find numbers that APPROXIMATELY hit a value. Not exactly
@bernardchrillyn60032 ай бұрын
What if I don't want decimals
@V-for-Vendetta017 ай бұрын
Cheers!
@10degreerule8 ай бұрын
I've sent you a message on messenger but no reply I'm hoping to get a reply here thank you in advance. I have 28 golfers in a group and we play every Monday how can I arrange so that each individual player will not play twice during the seven weeks. I was wondering if there was a formula pertaining to this project thanks
@wrathgaming5205 Жыл бұрын
hey how about generate without decimal points?
@AlwaysLearner27 Жыл бұрын
Format as number without decimal
@fredorivers4120 Жыл бұрын
How would the formula look like as number without decimal?