Thread: Excel Gurus
View Single Post
Old Apr 27, 2005 | 03:53 PM
  #13  
Rhys's Avatar
Rhys
15K+ Super Poster!!
 
Joined: May 2003
Posts: 18,745
Likes: 0
From: South Wales, GB
Default


Just doing this one now, but for some reason it aint working
=IF(C9=0,"0",IF(C9=1,"randbetween(800000,1000000)" ,IF(C9=2,"randbetween(800000,1000000)*2",IF(C9=3," randbetween(800000,1000000)*3",IF(C9=4,"Randbetwee n(800000,10000000*4")))))
Reply
0