Title:
Functions/Formulas in Excel 6 - Use Round and Rand to return Random Numbers with 2 Decimal Places
Video:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to generate Random Numbers in Excel that contain only 2 Decimal Places. The normal RAND function will output a lot of decimal places when you run it. However, sometimes you just want two decimal places. This tutorial shows you how to, in one step, combine the ROUND and RAND functions in Excel in order to create a formula that will output only two decimal places. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Published:
07/Nov/2009
Functions/Formulas in Excel 6 - Use Round and Rand to return Random Numbers with 2 Decimal Places
Video:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to generate Random Numbers in Excel that contain only 2 Decimal Places. The normal RAND function will output a lot of decimal places when you run it. However, sometimes you just want two decimal places. This tutorial shows you how to, in one step, combine the ROUND and RAND functions in Excel in order to create a formula that will output only two decimal places. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Published:
07/Nov/2009
No comments:
Post a Comment