excel question

[*mrgrizz*]

how do i do the following % sum in excel

a=cartons ordered,b=cartons supplied

a=100cartons,b=100 cartons...show as 100%

a=100 cartons,b =90 cartons...show as 90%

a=100 cartons,b=110 cartons..show as 110%

TIA

[*mrgrizz*]

should word that a little better

column a is quantity ordered

column b is quantity supplied

column c needs to be shown as a percentage.

100 ordered, 100 supplied = 100%

100 ordered, 90 supplied= 90%

100 ordered, 110 supplied= 110%

etc etc

[happyroo_bunji]

I'm having stupid head moments, you want to work out the percentage of stock on hand?

[aps1080]

Lets say the first number (100) is in cell A1, the other two below that.

2nd set of numbers at B1, the other two below that.

The Calculations in Column C are (top cell to bottom cell)

=SUM(B1/A1)

=SUM(B2/A2)

=SUM(B3/A3)

AND the cells are Formatted in the Numbers, Percentages, 2 Decimal places.

I hope that is clear as Mud

[alexander*beetle]

I think its =SUM(C4*100%). ie if your total is in C4 then use that. If it's in cell d4, use that. See if that works. 

[happyroo_bunji]

ok I see what you mean, I'll see if I can come up with anything.

Another dumb question, why do you want to know this, I mean its easy enough to see, you have 100 stock on hand thats 100%

[*mrgrizz*]

---

@happyroo_bunji wrote:

ok I see what you mean, I'll see if I can come up with anything.

Another dumb question, why do you want to know this, I mean its easy enough to see, you have 100 stock on hand thats 100%

---

cause sometimes you just got to do what you are told

thanks everyone will give it a whirl when back on my desktop

[happyroo_bunji]

---

@*mrgrizz* wrote:

---

cause sometimes you just got to do what you are told

thanks everyone will give it a whirl when back on my desktop

---

lol I understand

The formulas others posted should work

[*mrgrizz*]

it worked, thank you all

[aps1080]

Good to hear.