Related:

- I have problem in excel_sheet when using i eq
- Aimp eq - How-To - Software

Trowa

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

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

zam

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

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

Trowa

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

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

zam

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

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

Trowa

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

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