Random number equal to constant K

Hello! My client has given me the aggregate monthly sales details as follows: GST Sales Taxable: INR 15,180 GST Sales Exempted: INR 21,65,500 There is no day wise breakup. However, to enter t...

test file.xlsx12 KB

Formulas and Functions

Riny_van_Eekelen
Dec 06, 2019
a4avinash
Created a small model, based on your example. Using RAND() and a few extra parameters, it splits the monthly sales figure (entered at the top in F2) into daily sales. You'll note that the range of amounts is not really between 48000 and 75000 but it will not be as dramatic as you described.
You can play around with the "Lower" and "Range" parameters to get a split that you find acceptable.
test file_updated.xlsx13 KB

Riny_van_Eekelen

Platinum Contributor

Dec 06, 2019

a4avinash

Created a small model, based on your example. Using RAND() and a few extra parameters, it splits the monthly sales figure (entered at the top in F2) into daily sales. You'll note that the range of amounts is not really between 48000 and 75000 but it will not be as dramatic as you described.

You can play around with the "Lower" and "Range" parameters to get a split that you find acceptable.

test file_updated.xlsx13 KB

a4avinash

Copper Contributor

Dec 10, 2019

Thank you Mr. Riny. I really appreciate your timely response. Your formula is really helpful & I will adopt it in all my future workings.

Forum Discussion

Random number equal to constant K