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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Values in KG and LBs 4
Can I convert Imperial lbs to Stones and lbs in the same cell? 1
Adjacent Cell to Last Cell in a Row 1
convert values from LBs to KGs 1
how do i use excel to calculate weight (as in stone and lbs)? 6
What formula do I use for this? 1
Formula for Converting Kilos to Stones 3
info in cel needs to propt other cels to automatically enter text 2

Back
Top