I have problem in excel_sheet when using i eq [Closed]

Report
-
 Trowa -
Hello,
when i have convereted number of bottles in bottle/case , i haven't get proper result,
so pls give me your guidance

thanks

with regards,
zam.
Related:

5 replies

Hi Zam,

Your query is a little short; I don't know what you mean.

What is the result you are aiming for and what is the result you are getting.

Best regards,
Trowa
in my worksheet there are 3 columns first - qrt - 2- pint and 3 nip
qrt = 12 , pint = 24 , and nip = 48 no. of bottles per case
when i have fill no. of bottle in these column the sum of bottles were convereted in per case
e.g.
in qrt column
0.1 , 0.2 , 0.5 , 0.2 , 0.2 , 0.3 , 0.6 = 0.21 (sum) bottles
but i want result in per case i.e. = 1.9

so pls pls................. guidance me

with regards,
zam
Hi Zam,

It's a bit more clear now, but not all.

Why should the sum be 1.9 instead of the actual 0.21?

Waiting for your reply,
Trowa
In my worksheet there are 3 columns first - qrt - 2- pint and 3 nip
qrt = 12 , pint = 24 , and nip = 48 no. of bottles per case
when i have fill no. of bottle in these column the sum of bottles were convereted in per case
e.g.
in qrt column
0.1 , 0.2 , 0.5 , 0.2 , 0.2 , 0.3 , 0.6 = 0.21 (sum) bottles
but i want result in per case i.e. = 1.9 because
i put the formula of =sum(a2:a20)/12*100
but the result is =17.5
i want result is = 1.9

so pls pls................. guidance me

with regards,
zam
You are still asking the same thing:

1+1=2 but I want the answer to be 3.

This doesn't make any sense.

If you have 1 bottle in a case of 12 bottles then the case is filled with 1/12 bottles.
If you have 0.21 of a bottle in a case of 12 bottles then the case is filled with 0.21/12 bottles.

As you can see I still don't understand you.

By the way: the sum of 0.1 till 0.6 = 2.1

Maybe you can explain in a different way?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!