Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 05-28-2013, 02:01 AM
jeffk jeffk is offline +IF(RAND()........)   confused newbie Windows 7 64bit +IF(RAND()........)   confused newbie Office 2007
Advanced Beginner
+IF(RAND()........)   confused newbie
 
Join Date: Jul 2012
Location: North of England, UK
Posts: 32
jeffk is on a distinguished road
Default Thanks

Thank you, that clarifies the issue a bit, though I'm still not sure what you'd use the =IF(RAND().....) function for. Randomly selecting items/people/places in a list, maybe?


Thanks for your time & help,
Jeff
Reply With Quote
Reply

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 08:16 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