| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
| Formula to display cell reference (ex.. B7) | Excel Worksheet Functions | |||
| Formatting Cell To Display Value Instead Of Formula | Excel Worksheet Functions | |||
| Display formula in cell | Excel Discussion (Misc queries) | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
Linear Mode
