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!