Thank you for the quick answer, though! That was much quicker than I
anticipated!
--
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