Create Unit Calculator Using Google Doc Spreadsheet
We can create unit calculators using Google Doc spreadsheet for our day to day spreadsheet purpose. It can ease our job. You can create many types of unit calculators for your purpose. Right now I have some data of structural steel unit weight. I am using this data to create a structural steel unit weight calculator on the Google Doc Spreadsheet. You can apply the same method for creating any other unit calculators. I am detailing the steps in a video tutorial below. Before watching the video tutorial let me summarize what the tutorial is about.
We used the “data validation” feature and “sumif“ function for creating our unit calculator. Both these, you can learn watching the our below video carefully. If you find any problem to understand the tutorial, you can reach me by posting your queries below to comment.
Learn more about data validation.
Type the format in blue and red in a blank spreadsheet – see the video.
The data, which mentioned on the video below, that you want to use can be downloaded from here.
The “data validation” and “sumif“ are the two features used in the making of this unit calculator. That can easily be learned from the video tour itself.
Any problem? Post in comments.
About Article Author
It is very simple to convert a Google Doc Spreadsheet to Excel or PDF file format. Still we write this
We have a separate section on Info Inspired completely dedicated to Google Doc Spreadsheet Tutorials. In this post we can
This is an another awesome Google Doc Spreadsheet tutorial from Info Inspired team. Refer our growing dedicated Google Doc Spreadsheet
Learn how to use important logical functions IF, AND, OR in Google Doc Spreadsheet. Logical functions are very easy to
This is an ultimate tutorial for creating an advanced online form. Before coming to the tutorial few aspects about online
Hope you are a regular reader of our Google Doc Spreadsheet tutorials. We already have some rich content there to