how to use convert formula in Excel part 1
On the off chance that you've ever need to make an interpretation of Celsius to Fahrenheit, miles to kilometers, or teaspoons to mugs, all you require is the helpful CONVERT work in Excel.
Basically enter your esteem, its estimation unit, and the objective unit for change, and you'll find your solution. Here are some helpful cases:
=CONVERT(30.4,"C","F")
=CONVERT(65,"mi","km")
=CONVERT(10,"tsp","cup")
You don't have to remember the majority of the units that are accessible. Simply sort "=CONVERT(" trailed by the esteem. When you enter the comma to move to the units area of the capacity, you'll see a rundown of accessible units to browse in the equation bar:
Select units for CONVERT work
Utilize the scrollbar to discover your unit and either double tap or snap + TAB to choose it. At that point enter another comma after the unit's nearby quote to raise the rundown again to choose your objective unit, and afterward shut the enclosure and hit Enter.
Simply make sure that the units you select for both are connected estimations or you'll get a blunder. You can't change over years to pounds, for example. Luckily, Excel as a rule compels the rundown of accessible measures to ones that match your beginning unit:
Select target units
Note that not every single accessible unit might be recorded. While changing over miles, I just discovered meters - however evolving the "m" to "km" brought about transformation to kilometers.
Suzanne
Labels Excel capacities Office 2007 Office 2010
watch live how to do this
Wednesday, 20 September 2017
how to use convert ofrmula in EXcel part 1
All course of Excel
0 comments:
Post a Comment