Divide into three (excel 2003)

Topic

New Reply

Subject edited by HansV – “excel 2003” wasn’t very descriptive.

Hello,

I have a formulat in many different cells that takes 1/3 of an amount and puts it in three different cells. My question is a as follows. If I put a number such as $25,000 it will display $8,333 in all of the three other cells. I would like to do a format so it can add to the $25,000. I tried adding a 1 at the end, but if I do that and the number is $30,000, it would give me $10,000 in the first two cells and $10,001 in the last cell which would add to $30,001. Any help would be great.

Reply | Quote

Replies

Instead of putting 1/3 of the number in all three cells, put 1/3 of the number in the first two cells. In the third cell put the number minus the first two cells. You will probably also want to round all of the cells to a whole number. If 25,000 is in A1, then put this formula in the first two cells:


=ROUND(A1/3,0)


Then if those two formla are in C1 and C2, then put this formula in the thrid cell:


=A1-C1-C2


Reply | Quote

Thanks LegareColeman that works.

Reply | Quote