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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)"
 
Back
Top