{"id":18678,"date":"2016-11-10T23:10:29","date_gmt":"2016-11-10T23:10:29","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18678"},"modified":"2016-11-10T23:11:08","modified_gmt":"2016-11-10T23:11:08","slug":"spreadsheets-excel-convert-function","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-excel-convert-function\/","title":{"rendered":"Spreadsheets: Excel: convert() function"},"content":{"rendered":"

The tutor mentions Excel’s convenient conversion utility.<\/h1>\n

I used to wonder, casually, what a nautical mile is compared to an ordinary mile. Not anymore: today I discovered Excel’s convert() formula, which is among the Engineering ones in More Functions, in the Formulas pane. convert() has many possibilities, which you can discover by selecting it, then clicking “Help on this function”.<\/p>\n

The basic syntax is<\/p>\n

=convert(quantity, “first_unit”,”second_unit”)<\/p>\n

To convert one nautical mile to regular miles, for instance, I key in<\/p>\n

=convert(1,”Nmi”,”mi”)<\/p>\n

Excel responds with 1.150779.<\/p>\n

For cups to litres, I key in<\/p>\n

=convert(1,”cup”,”l”)<\/p>\n

Excel responds with 0.23664.<\/p>\n

HTH:)<\/p>\n

Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

The tutor mentions Excel’s convenient conversion utility. I used to wonder, casually, what a nautical mile is compared to an ordinary mile. Not anymore: today I discovered Excel’s convert() formula, which is among the Engineering ones in More Functions, in …<\/p>\n

Spreadsheets: Excel: convert() function<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1907,1583,1009,181,1065],"tags":[2018,2016,2017],"class_list":["post-18678","post","type-post","status-publish","format-standard","hentry","category-cooking","category-excel","category-home-computer-use","category-lifestyle","category-spreadsheets","tag-cup-to-liter","tag-excel-convert-function","tag-nautical-mile-to-regular-mile"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=18678"}],"version-history":[{"count":4,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18678\/revisions"}],"predecessor-version":[{"id":18682,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18678\/revisions\/18682"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}