Calculation
 

Can u pls solve this


Packs Quantity Total
500Kg 10 #VALUE!

i need the total value as 5000Kg

Calculation
 

=LEFT(A1,3)*B1 & "Kg"
--
Gary''s Student - gsnu200804

Calculation
 

what if the digits r more than 3 or different digits how to do it can u pls
help

"Gary''s Student" wrote:

=LEFT(A1,3)*B1 & "Kg"
--
Gary''s Student - gsnu200804

Calculation
 

And just to expand on GS's reply,
=LEFT(A1,LEN(A1)-2)*B1&"Kg"

will allow for pack sizes to be 1Kg or 2.5Kg or 5000Kg
or whatever.

HTH
Martin



"Gary''s Student" wrote in message
...
=LEFT(A1,3)*B1 & "Kg"
--
Gary''s Student - gsnu200804

Calculation
 

thanks soo much

"MartinW" wrote:

And just to expand on GS's reply,
=LEFT(A1,LEN(A1)-2)*B1&"Kg"

will allow for pack sizes to be 1Kg or 2.5Kg or 5000Kg
or whatever.

HTH
Martin



"Gary''s Student" wrote in message
...
=LEFT(A1,3)*B1 & "Kg"
--
Gary''s Student - gsnu200804

Calculation
 

can u help me to get the grand total too

Packs Quantity Total
500Kg 10 5000$
600kg 25 15000$
500kg 10 5000$
60000kg 5 300000$




Grand Total #VALUE!

"sajith" wrote:

thanks soo much

"MartinW" wrote:

And just to expand on GS's reply,
=LEFT(A1,LEN(A1)-2)*B1&"Kg"

will allow for pack sizes to be 1Kg or 2.5Kg or 5000Kg
or whatever.

HTH
Martin



"Gary''s Student" wrote in message
...
=LEFT(A1,3)*B1 & "Kg"
--
Gary''s Student - gsnu200804

Calculation
 

I supposed that you have Total in column D and you have 5000kg as in your
first post and not 5000$.
=SUM(VALUE(LEFT(D8:D11,LEN(D8:D11)-2)))
as an array formula (confirmed with Ctrl+Shift+Enter).
Anyway I suggest in order of easier usage to use pure numbers and to place
measure of unit in the header or in a separate column.

If cell contents are really 5000$, etc. then the formula is
=SUM(VALUE(LEFT(D8:D11,LEN(D8:D11)-1)))

Regards,
Stefi

€žsajith€� ezt Ã*rta:

can u help me to get the grand total too

Packs Quantity Total
500Kg 10 5000$
600kg 25 15000$
500kg 10 5000$
60000kg 5 300000$




Grand Total #VALUE!

"sajith" wrote:

thanks soo much

"MartinW" wrote:

And just to expand on GS's reply,
=LEFT(A1,LEN(A1)-2)*B1&"Kg"

will allow for pack sizes to be 1Kg or 2.5Kg or 5000Kg
or whatever.

HTH
Martin



"Gary''s Student" wrote in message
...
=LEFT(A1,3)*B1 & "Kg"
--
Gary''s Student - gsnu200804

Calculation
 

Hi

For the cells holding the pack sizes, FormatCellsNumberCustom General
"Kg"
Just enter the values in the cell, e.g 500 and it will appear as 500 Kg
For your Totals it is then what you already have
=A2*B2

--
Regards
Roger Govier

"sajith" wrote in message
...
Can u pls solve this


Packs Quantity Total
500Kg 10 #VALUE!

i need the total value as 5000Kg