even divisible

[Fahsid1230]

Hi Folks,
is there a way or formula where if I put a certain number and results can came out in whole number summing back to the original number?
For example:
if I put 83 in cell A1 can I have an even distribution of 83 a(no decimals) as close as possible in A2, B2, C2& D2?
A1=83
the result should be :
A2=22; B2=22; C2=22 & D2=23

Any help will be appreciated
thx

 

[Barry Katcher]

Try the formulas in A1:D2 below. And actually, the results should be 21, 21, 21 & 20.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

 

[Fahsid1230]

This is exactly what I was looking for. And your math is correct.
Thank you so much.