This function can convert most of the values that you’re most interested in converting and the function is easy enough to use for quick conversions. The function can also be used in a small worksheet that offers a permanent solution for making those calculations that you commonly use.
The convert formula takes three values – the number you want to convert, a code for the units to convert from and a code for the units to convert to. The codes must be placed inside a pair of double quotation marks. We’ll start out by writing a simple convert formula so you can see how it works and then we’ll build a simple worksheet that you can use to make those conversions that you are most interested in performing on a regular basis.
Notice that as you type the first comma a dropdown list appears from which you can select unit to convert. This makes it easy for you to see what units you can convert using this formula and what code to use for each unit. For example you will see that C is the code for Centigrade and F is the code for Fahrenheit.
Creating a conversion worksheet like this will allow you to convert values at any time.
If you save this worksheet then at any time you can open it and type the number of tablespoons, for example, in cell blank and you’ll know immediately how many teaspoons that is.