Divide the total in one cell into up to 6 others
hi
assuming the 65 is on the a2
on b2 use:
=$a2/6
copy it util f2
and on g2 use a2-sum(b2:f2)
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Dos Equis" escreveu:
Hi,
Does anyone know how to divide the number in one cell and have up to 6
other cells equal the original number? i.e. 65 = 11, 11, 11, 11, 11,
10.
Thanks for any help
Byron
|