Related:
- I have problem in excel_sheet when using i eq
- Graphic eq download - Download - Other
- Vlc eq - Guide
- Spotify eq - Guide
5 responses
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
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
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
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
Didn't find the answer you are looking for?
Ask a question
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
