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

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.
 
G

Guest

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
Formula in Comment 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
get Cell to not display ( $ - ) 3

Top