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”)