Thread
:
Help please, Trout returns in an excel spread shee.t
View Single Post
#
9
February 18th, 2005, 09:32 PM
simon
external usenet poster
Posts: n/a
Where cell A1 contains a numeric value in kg, for the stones part use:
In one cell
=INT(CONVERT(A1,"kg","lbm")/14)
for the remainder in pounds:
in another cell
=MOD(CONVERT(A1,"kg","lbm"),14)
simon