Okebiz Video Search



Title:Functions/Formulas in Excel 6 - Use Round & Rand to return Random Numbers with 2 Decimal Places
Duration:115
Viewed:19,380
Published:06-11-2009
Source:Youtube

Visit http://www.TeachExcel.com for more, 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://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

SHARE TO YOUR FRIENDS


Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Excel Functions: RAND and RANDBETWEEN Excel Functions: RAND and RANDBETWEEN
05:00 - 136
Formulas in Excel 1 - Round Numbers in Excel with Round Function to the Nearest Decimal or Integer Formulas in Excel 1 - Round Numbers in Excel wi...
05:45 - 477
Generate Random Numbers with Decimals in Microsoft Excel Generate Random Numbers with Decimals in Micros...
04:31 - 50
50 Ultimate Excel Tips and Tricks for 2020 50 Ultimate Excel Tips and Tricks for 2020
50:17 - 368
COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com COMBINE Multiple Excel WORKBOOKS into One | Exc...
05:59 - 372
Round Formula in Excel | Excel Formulas | Excel Tutorial Round Formula in Excel | Excel Formulas | Excel...
06:37 - 960
Advanced Excel - Creating Pivot Tables in Excel Advanced Excel - Creating Pivot Tables in Excel
13:11 - 767
Create a List of Random Numbers without Repeats Create a List of Random Numbers without Repeats
05:58 - 54