topic Re: excel question in Community Spirit

excel question

*mrgrizz* — Mon, 15 Dec 2014 03:37:00 GMT

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

Re: excel question

*mrgrizz* — Mon, 15 Dec 2014 03:58:23 GMT

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

Re: excel question

happyroo_bunji — Mon, 15 Dec 2014 03:58:52 GMT

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

Re: excel question

aps1080 — Mon, 15 Dec 2014 04:00:23 GMT

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

Re: excel question

alexander*beetle — Mon, 15 Dec 2014 04:02:42 GMT

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.

Re: excel question

happyroo_bunji — Mon, 15 Dec 2014 04:03:13 GMT

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%

Re: excel question

*mrgrizz* — Mon, 15 Dec 2014 04:07:14 GMT

@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

Re: excel question

happyroo_bunji — Mon, 15 Dec 2014 04:09:49 GMT

@*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

Re: excel question

*mrgrizz* — Mon, 15 Dec 2014 04:18:19 GMT

it worked, thank you all

Re: excel question

aps1080 — Mon, 15 Dec 2014 04:45:41 GMT

Good to hear.

excel question

rabbitearbandicoot — Mon, 15 Dec 2014 06:56:58 GMT

why would the C column be =SUM(b1/a1) ? surely it would be just =b1/a1 with the C column formatted as a Percentage?

Maybe I'm missing something?

Re: excel question

aps1080 — Mon, 15 Dec 2014 07:30:11 GMT

I think you end up with the same thing.

I use the epsilon symbol - i think that is what it is called.

Re: excel question

poddster — Mon, 15 Dec 2014 09:43:43 GMT

The caculation sort pf falls apart if you ordered 0 ans got sent some

But you are ahead anyway 🙂

Re: excel question

poddster — Mon, 15 Dec 2014 10:10:30 GMT

You can get around the 0 in cell A if you put this in cell C

=IF(A1<=0,"Yipee a freebie",B1/A1)