Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 05-27-2013, 05:26 PM
Kimberly Kimberly is offline +IF(RAND()........)   confused newbie Windows 7 64bit +IF(RAND()........)   confused newbie Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Quote:
what is being compared to 0.5 to decide whether to return "yes" or "no"?
The result of the RAND function.

The result of the RAND function is not being displayed, but is being used inside the logical test of the IF function.

The RAND() function returns a number >=0 and <1. It stands to reason then that it would return something less than .5 about half the time.
There is no "50% of" anything. There is a random number between 0 and 1. If this time it would be less than .5, your formula returns "yes", otherwise, it returns "no".
Reply With Quote
 

Tags
functions, rand



Similar Threads
Thread Thread Starter Forum Replies Last Post
+IF(RAND()........)   confused newbie Newbie, need help urgently!!!!!!!!! Ali Publisher 2 03-16-2012 07:22 AM
+IF(RAND()........)   confused newbie newbie help please cjpga Outlook 2 06-23-2011 01:24 PM
+IF(RAND()........)   confused newbie Range Lookup for Totals? Confused lawnG Excel 1 02-01-2011 10:42 AM
+IF(RAND()........)   confused newbie Field Lookup - Confused lawnG Word Tables 1 01-31-2011 03:50 PM
+IF(RAND()........)   confused newbie Need Backup/Export - confused! Robin12265 Outlook 2 06-04-2006 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft