#1
|
|||
|
|||
convert command query
old pc running windows 10 home with ms office XP, (pc not attached to wifi, just used as a word processor), I have 2 columns on a spreadsheet, one lbs, the other kgs,
when I put the weight in column E in lbs, I want column H to automatically convert to kgs, I am using =convert(E3,"lbm","kg") in cell H3, I am getting the error message #NAME?, can anybody please advise me on where I am going wrong, all help and advice appreciated |
#3
|
|||
|
|||
thank you NoSparks, for your prompt reply, I appreciate your help and advice
|
#4
|
|||
|
|||
1kg = 2.20462262 lbs
Make your own formula |
#5
|
|||
|
|||
thank you trevorc, much appreciated
|
#6
|
|||
|
|||
thank you trevorc, your help and advice is appreciated
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Command button. To multi command | Taylormations | Word VBA | 11 | 09-14-2020 02:39 AM |
Show table list by using chek box command and save document on sharepoint by using command button | Zhibek | Word VBA | 3 | 08-16-2018 06:19 PM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
command button query | smalc | Word VBA | 2 | 03-16-2015 08:26 PM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |