Forum Discussion
ashunjoy_1911
Sep 03, 2020Copper Contributor
Excel- Split a number
Dear Sir, I am facing problem in excel for splitting a number into different random parts Like I want to split 45 into 7 random parts "1st part between 0-12" " 2nd part between 0-12" " 3rd ...
- Sep 03, 2020
Dear Dr. Sharma
Please find a file that has a VBA script.
input your number in cell A1 (for example 45)
the function will use randbetween... until the sum will be 45
if you want 55, just change the value in cell A1
best regards
Ramiz_Assaf
Sep 03, 2020Iron Contributor
Dear Dr. Sharma
Please find a file that has a VBA script.
input your number in cell A1 (for example 45)
the function will use randbetween... until the sum will be 45
if you want 55, just change the value in cell A1
best regards
ashunjoy_1911
Sep 03, 2020Copper Contributor
Sir, I got stuck in my original file.
Can you give a generous solution for the attached file?
- Ramiz_AssafSep 03, 2020Iron Contributor
Press F9 to generate solutions
accepted solutions will become green
keep pressing F9 until all the column becomes green
hope this solution work, I dunno what to do with fractions (round up or down)
- Qusai_JanadaDec 23, 2022Copper Contributor
- ashunjoy_1911Sep 04, 2020Copper Contributor
Thank you Assaf
Actually the excel shows me error in the formula as I am using Office 2016
In 2016 "IFS" function is not working. "IFS" function is introduced after 2016.
Error- =_xlfn.IFS($B$1=0,0,$I16<>$A16,RANDBETWEEN(B$3,B$4),TRUE,B16)
Can you provide nested IF, Please
- Ramiz_AssafSep 04, 2020Iron Contributor