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
|