RAND() is volatile; it recalculates every time the spreadsheet is
recalculated. Perhaps that is screwing up your calculations. Why not
generate a list of random numbers, copy them, paste them as values, and then
run your other formulas off those values?

Dave
--
Brevity is the soul of wit.


"47u2caryj" wrote:

Having difficulty adding rand generated numbers, trying to create practice
worksheets for students using basic operations and integers.
A1: can be interchangable with +,-,x,or/
B2 C2 are the upper limits of numbers
B3 C3 the lower limits
B4...B23 is a rand() using B2 and B3 as limits; formula =RAND()*(B$2-B$3)+B$3
C4...C23 is a rand() using C2 and C3 as limits; formula =RAND()*(C$2-C$3)+C$3

Problem arises HERE when trying to create solution sheet:
=SUMPRODUCT(($A$1="+")*($B4+$C4)+($A$1="-")*($B4-$C4)+($A$1="X")*($B4*$C4)+IF($B4<"",($A$1="/")*($B4/$C4),0))
Solutions are frequently off, e.q. generated numbers "5+19" solution sheet
says "25" is it something with the way the numbers are generated?
Perplexed!