Forum Discussion
Excel Formulas
Hi Im populating some figures, but i would like to know a way I can randomise numbers. E.g If I have Mon, tues, wed, thur, fri etc with a numbered total at the end of the week be it 1000...ho...
If your labels for each day of the week are in A1:G1, H1 contains “Total”, A2:G2 are the random numbers, and H2 contains the predetermined sum, the formulas are:
1. A2:F2=RANDBETWEEN(1,H2/7)
2. G2=H2-SUM(A2:F2)
The foregoing formulas return G2 as the balancing number, which is at least equal to the result of H2/7.
1. A2:F2=RANDBETWEEN(1,H2/7)
2. G2=H2-SUM(A2:F2)
The foregoing formulas return G2 as the balancing number, which is at least equal to the result of H2/7.