Fahsid1230
Active Member
- Joined
- Dec 26, 2006
- Messages
- 282
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
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