• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Some details about Convert Function

ThrottleWorks

Excel Ninja
Recently I learnt 2 new (very good) functions, “Get.Name” & “Info”, thanks to Debraj & SirJB7.

After reading these threads.
I was trying to search if there are more such informative functions which I did not know.

And while searching I stumbled upon “Convert” function.
I am sure many of the Forum members must have already used this, but I saw this for first time.

MS describes this functions as below,
“Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers”.

While working on this I discovered some interesting things, Convert can translate Teaspoon to U.S. Pint also.
For example 1,000 Teaspoon is to 10 U.S. Pint. Not sure though how many have used this in real life situation.

I have attached my working for the reference.

Happy Cristmas !
 

Attachments

  • Convert.xls
    424.5 KB · Views: 4
Thanks for the link @Debraj Sir !

There are so many variations in the link which I have not included.
These were not available on my PC :eek:, for example "Modern Teaspoon" :DD, thanks to the link I know them now.

Happy Christmas & have a wonderful year ahead. :)
 
Back
Top