Yeah, I've got that down. Actually, we're working only with add & subtract
right now. I've got random number generators (that will automagically put the
bigger number on top). But I want the solutions to be unique. The solutions
point to letters in the alphabet, to solve a riddle.
--
Adios,
Clay Harryman


"Bernie Deitrick" wrote:


Clay,

If you aren't at the level that you're teaching that any number / 0 is undefined, then use this in
Cell B1

= 1 + ROUND(RAND()*11,0)

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Clay,

What kind of math problems are you looking at creating?

You could use sets of formulas like this, to create a division problem in cell D1:
Cell A1 =ROUND(RAND()*12,0)
Cell B1 =ROUND(RAND()*12,0)
Cell C1 =A1*B1
Cell D1 = C1 & " / " &B1 &" = ?"

Each press of F9 will create a new division problem, selected from up to the 12 times tables.

HTH,
Bernie
MS Excel MVP


"Clayman" wrote in message
...
I am developing a math lesson worksheet for my homeschool lessons. One way
it's working quite well is to use the solutions of problems to find a letter
code. I would like to have the following attributes:
1.) 26 randomly-generated math problems, each with a unique solution.
2.) Not write a bunch of VB code to do it. (I'm kinda burned out on that).

Is there an easy solution? If you would like to see what I have so far,
please request it and I'll e-mail it to you. There is no VB on it right now,
so you can open it with macros turned off.
--
Adios,
Clay Harryman