Display in same cell lbs(kgs) using formula to auto-convert lbs
 

I would like to have a cell show #lbs(#kgs) in that format. But have the kgs
measurement autoconvert from the entered lbs number. So the formula would
look something like this Xlbs(Ykgs=X*0.454). I would also similarily like to
have a #in(#cm) cell setup but I am guessing it would resemble the prescribed
solution formula and only differ in the multipied conversion number. Thanks.

Display in same cell lbs(kgs) using formula to auto-convert lbs
 

Do you want the input and display in the same cell? You won't be able to do
that without VBA. But if you input a number in A1, e.g. 25 you can make B1
display

25lbs(11.35kgs) with a formula like

=A1&"lbs("&A1*0.454&"kgs)"

"Ian Burnby" wrote:

I would like to have a cell show #lbs(#kgs) in that format. But have the kgs
measurement autoconvert from the entered lbs number. So the formula would
look something like this Xlbs(Ykgs=X*0.454). I would also similarily like to
have a #in(#cm) cell setup but I am guessing it would resemble the prescribed
solution formula and only differ in the multipied conversion number. Thanks.