View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ian Burnby Ian Burnby is offline
external usenet poster
 
Posts: 1
Default 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.