Hello guys,
I have the randbetween value in a cell and the multiple value in the other cell. I want to get values with the help of randbetween formula in cells H2 to H15. I want the formula to select the randbetween amount from the cell B2 and the multiples value from the cell C2. How do I combine the above 2 formulas into one and get the result?
If , in the B column, I write the value as 6-10, it is not accepting in the general format. Since, multiples is used in most of the cases, I would like to know how to enter 6-10 or directly 6,10 which also is not accepted by excel in the required format. Something like this '=RANDBETWEEN(SUBSTITUTE(B2,"-",")*C2 but it ain't working.
Bookmarks