Can u pls solve this


Packs Quantity Total
500Kg 10 #VALUE!

i need the total value as 5000Kg

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

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

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

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

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

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

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