formula that gives me a random number less than other number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that looks at a number and gives me a random number that is
less than the original number. I'm trying to set up an automatic page with
substraction problems for my 2nd grader.
 
You can use RANDBETWEEN but you need to load the Analysis Tool Pack.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Numbers with certain numbers more common than others 5
Random Numbers and Me 4
Random numbers from several ranges 3
Combining sumIF statements with other functions? 2
conditional formating less than % of previous day 3
How can I use the same random number twice in the same formula? 2
selecting an item at random for QA sampling 1
Trying to randomly choose a number from a set list of numbers 8

Back
Top