Microsoft KB Archive/127204

= Microsoft Knowledge Base =

XL: RANDBETWEEN Returns an Incorrect Answer with Fractions
Last reviewed: September 13, 1996

Article ID: Q127204

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a
 * Microsoft Excel for Windows 95, versions 7.0, 7.0a

SUMMARY
The RANDBETWEEN function will not return the correct answer if the arguments given to the function contain a decimal point. If the arguments contain decimal points, the function will return a fractional number, which is incorrect.

MORE INFORMATION
RANDBETWEEN returns a random integer between the numbers that you specify. A new random number is returned every time the worksheet is calculated.

This function is available when the Analysis ToolPak is installed.