Calculation

[sajith]

Can u pls solve this


Packs Quantity Total
500Kg 10 #VALUE!

i need the total value as 5000Kg

 

[Gary''s Student]

=LEFT(A1,3)*B1 & "Kg"

 

[sajith]

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

 

[MartinW]

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

 

[sajith]

thanks soo much

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

 

[sajith]

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!

 

[Stefi]

I supposed that you have Total in column D and you have 5000kg as in your
first post and not 5000$.
=SUM(VALUE(LEFT(D811,LEN(D811)-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(D811,LEN(D811)-1)))

Regards,
Stefi

„sajith†ezt írta:

 

[Roger Govier]

Hi

For the cells holding the pack sizes, Format>Cells>Number>Custom> 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