Microsoft Office Tutorials and References
In Depth Information
Converting Between Measurement Systems
In some situations, the CONVERT function requires some creativity. For example, what if you
need to convert ten square yards to square feet? Neither of these units is available, but the
following formula does the job:
=CONVERT(CONVERT(10,”yd”,”ft”),”yd”,”ft”)
The nested instance of CONVERT converts ten yards into feet, and this result (30) is used as the
first argument of the outer instance of the function. Similarly, to convert ten cubic yards into unit
cubic feet, use this formula:
=CONVERT(CONVERT(CONVERT(10,”yd”,”ft”),”yd”,”ft”),”yd”,”ft”)
 
Search JabSto ::




Custom Search