Forum Discussion
Solved
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 ...
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
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
I am really grateful that you have taken up this task.
You really become an escape boat for me.
Regards
Dr. Ashish