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.

REFERENCES

For more information about the RANDBETWEEN() function, choose the Search button in Help and type: 

   randbetween

KBCategory: kbtool
KBSubcategory:

Additional reference words: 5.00 7.00 random



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.