View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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