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 !
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 !