Using ROUNDDOWN function need help

[peblez]

Can someone show me how I can get this done?
A1 - 65
A2 - =A1*.5
A3 - =A1*.3
A4 - =A1*.2

Result would be
A2 - 32.5
A3 - 19.5
A4 - 13

But I want it to show A2 as 32, A3 as 19, With the left over in A5. so A5 would have to result in 1.

Also need help with this.

A6 - =(A2+A3)/2
A7 - =(A2+A3+A4)/3

Result would be
A6 - 26
A7 - 21.67

But i need the results to show A7 as 21, and A8 as 3 (the leftover)

Is it possible to do that?

[Sam Capricci]

This should work for your first issue =ROUNDDOWN(A1*0.5,0) and just repeat for A3 and A4 etc.
I'm not clear on your second issue A6 - =(A1+A2)/2 because that would result in 48.75 if A1 is 65 and A2 is 32.5
you might need to better define that one.

[peblez]

sorry i meant A2+A3. I fixed the OP

[Sam Capricci]

ok, if you use the rounddown formula i gave you in cells A2, A3 and A4, then refer your formulas in A6 and A7 to those cells then format as no decimal places you should get your first set of expected results and your second set. As for A8, I'm not sure what you are using to get a 3.

[martindwilson]

duplicate post ..deleted

[martindwilson]

a2 =ROUNDDOWN($A$1*0.5,0)
a3 =ROUNDDOWN($A$1*0.3,0)
a4 =ROUNDDOWN($A$1*0.2,0)
a5=a1-sum(a2:a4)
note with those multipliers that is the equivalent of multiplying a1 by 1

[peblez]

think of it in terms of dollars. 65 dollars divided by 3 would yield 21.67 each. but i need that number to round down to the nearest dollar, so it would be 21 dollars each with 0.67, 0.67, 0.66 left from each of the 3 person. well i need those leftover (breakerage) to be added up with the total in A8.

[peblez]

a2 =ROUNDDOWN($A$1*0.5,0)
a3 =ROUNDDOWN($A$1*0.3,0)
a4 =ROUNDDOWN($A$1*0.2,0)
a5=a1-sum(a2:a4)
note with those multipliers that is the equivalent of multiplying a1 by 1

Worked great. now how do i put it for my A6 through A8.
Those dang $ is throwing me off. never used them in excel before.

[Sam Capricci]

I'm glad you liked Martin's answer but wasn't it the same one I gave you? (not to take anything from him but was my answer not clear enough?)

[peblez]

I'm glad you liked Martin's answer but wasn't it the same one I gave you? (not to take anything from him but was my answer not clear enough?)

Sambo yours was the same thing and you was first. but martin gave me the main thing i needed with was the A5. still looking for the formula in A8 though

[Sam Capricci]

understand, still working on one. Maybe Martin will get it to you faster than I can.

[peblez]

Can someone show me how I can get this done?
A1 - 65
A2 - =A1*.5
A3 - =A1*.3
A4 - =A1*.2

Result would be
A2 - 32.5
A3 - 19.5
A4 - 13

But I want it to show A2 as 32, A3 as 19, With the left over in A5. so A5 would have to result in 1.

Also need help with this.

A6 - =(A2+A3)/2
A7 - =(A2+A3+A4)/3

Result would be
A6 - 26
A7 - 21.67

But i need the results to show A7 as 21, and A8 as 3 (the leftover)

Is it possible to do that?

I just realized I made a mistake if im using the ROUNDDOWN function. I need to go back to the orginal amount.
A6 would have to be =(A1-A4)/2
A7 would be =A1/3

A6 would result in 26
A7 would result in 21.67

Need A7 to show 21
Need A8 to show 2 (0.67+0.67+0.66, from the leftover)

[peblez]

I just realized I made a mistake if im using the ROUNDDOWN function. I need to go back to the orginal amount.
A6 would have to be =(A1-A4)/2
A7 would be =A1/3

A6 would result in 26
A7 would result in 21.67

Need A7 to show 21
Need A8 to show 2 (0.67+0.67+0.66, from the leftover)

I think i figured it out.
A8 would be =A1-SUM(A7*3)

Thanks so much guys for putting me on the right track.