Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

randbetween function in excel


  • Please log in to reply
1 reply to this topic

#1 abcd_1

abcd_1

  • Members
  • 91 posts
  • OFFLINE
  •  
  • Local time:02:28 PM

Posted 28 June 2009 - 02:22 AM

Hi ..

i am xl newbie.

using Ms Office 2007

i tried using randbetween(0,100) function. and produced a column of marks.

then used vloopup function to assign grades to students.

then saved the document and reopened.

upon every opening of the document the "marks " columns are changing and hence the "Grades" column also.

i want marks, not to change until i manually change.

my question is on using randbetween() function, is it its property to change the values of the cells it is applied to on every reopening of the document?

1)please explain the behaviour of randbetween()!!

2) Also please tell me if i am asking to change the nature of randbetween () function..

Thanks for all the help friends

BC AdBot (Login to Remove)

 


#2 abcd_1

abcd_1
  • Topic Starter

  • Members
  • 91 posts
  • OFFLINE
  •  
  • Local time:02:28 PM

Posted 30 June 2009 - 12:41 PM

Guys was is such a tough questinon that i asked.

request help from the senior computer guys..

please ...

thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users