For that, you can refer my below blog post (it’s an old post though)
If you want you can create a custom unit converter by using functions like SUMIF or Vlookup.
#Google unit calculator how to
Hope you could understand how to create Unit Converter in Google Sheets. With this settings, you can restrict other users from entering values other than the number in the range. To do this you can use the below ISNUMBER formula in Data Validation. The Iferror function removes such errors and returns blank.įinally, if you want you can select the range C2: C14 and set a validation rule as below. That means if there is no value in any of the cells in C2: C4 or no units selected for conversion, the formula will return #N/A error in those cells. The use of Iferror function in this formula is to return a custom value (here blank) if there are error values in any cells in the result. So no need to apply this formula in each and every rows. Now the last step is applying the conversion formula. You are almost learned how to create Unit Converter in Google Sheets. For example, for the category “Distance” the reference will be “Sheet1!B2: B13” Step 5: But you should change the data validation criteria reference from “Sheet1!A2: A13” to corresponding column references. For example, set the data validation in D3 for the category “Distance” and copy the settings to E3. Step 4:įollow the same steps in Step 3 for all the categories. It’ll automatically copy the data validation settings to E2. You have created one drop down menu for the category “Weight”. Make sure that everything is as per the above validation settings and click “Save”. This’s the range that contains the different units for the category “Weight”. To select the range click the square box on the corner of the field. Against the “Criteria” you should select “List from a range” in the drop-down and then in the field adjoining to it, select or enter the range Sheet1!A2: A13. This setting is available under the menu Data. Go to the cell D2 and set the data validation as below. You can follow the same steps for other categories in the rows below. I will explain here how to do it for the category “Weight” in cell A2. Now I am going to create a simple drop-down menu for each category. Then enter the column labels in the range C1: F1. In my above-shared sheet, from “Sheet2” copy the content in the column range A2: A14 and pasted it in your sheet in the same range in a new tab. In a new tab, I am going to create the Unit Converter. If you don’t have time now to do the experiment, no need to have a wild guess on what is in that sheet. It should be copied in the range A1: M26. Go to this Google Sheet and Copy the content in the “Sheet 1” to your sheet. You May Also Like: Amount or Numbers to Words Converter Using Google Sheets Steps to Create Unit Converter in Google Sheets Step 1:
Now let me first explain you, how to create Unit Converter in Google Sheets. It’s a sample Unit Converter in Google Sheets. In my example sheet, which is shared at the end of this spreadsheet tutorial, you can see all the available categories and units. Needless to say, you can convert unit under one category to another unit under the same category. This way you can use any available units in covert. This Convert formula converts the value 1 from kilogram to gram (kg to g). Under this, there are different units of conversion which I’ve not shared above. For example, if you check the above list, the first category is Weight. Start unit and end units are the units that are coming under the above categories. Here value is the number that you want to convert from one unit to another. The syntax of Google Sheets Convert Function. How to Use Convert Function in Google Sheets Please refer this Google Doc Editor’s help page for more info.įirst, learn the usage of the convert function then I will take you to how to create Unit Converter in Google Sheets using this function. Under these categories, there are different subcategories. I think this function is best for engineers.īelow are the available conversion unit categories. With this unit converter, in your Google Sheets, you can convert values from one unit to another. So first learn how to use CONVERT Function in Google Sheets. Other than CONVERT you only need to use the Data Validation menu option. For this purpose, I am using the Convert Function. Today you can learn how to create Unit Converter in Google Sheets.