Rand and If

		Microsoft Office Forums > Microsoft Excel > Excel
Rand and If

FAQ

Thread Tools

Display Modes

01-03-2018, 12:49 PM

NBVC

Windows 10 Rand and If

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

You can also shorten the formulas to:

=RANDBETWEEN(CHOOSE($C$10,1,10,100,1000),CHOOSE($C $10,9,99,999,9999))

and

=MIN($H$3,RANDBETWEEN(CHOOSE($C$10,1,10,100,1000), CHOOSE($C$10,9,99,999,9999)))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
+IF(RAND()........) confused newbie	jeffk	Excel	6	05-28-2013 08:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 PM.