second grader homework

[second grade parent]

Hi I am trying to work on a puzzle for my second grader to learn math. I am trying to dupelicate it in excel with rand number generator. Its a subtraction problem and sometimes the second number or third # is bigger than the first. Is there a way to program excel to hit F9 if the result is negative.
its kind of like sudoku:
A1 blank
A2 =(B1+C1)-A3A3 =RANDBETWEEN(6,12) this is supposed to be a1-a2 this is supposed to be a positive number
B1 = RANDBETWEEN(6,10)
B2 blank
b3 =B1-(A2-C2) this is supposed to be B1-B2 and this is supposed to be a positive number
C1 = this is supposed to be a1-b1 this is supposed to be a positive number
c2 this is supposed to be a2- b2 this is supposed to be a positive number.

how should i program this to only result in positive number?

 

[Leith Ross]

Hello second grade parent,

To return any number as positive use the ABS Absolute Value function.

Example:
C1 = ABS(A1-B1)

 

[shg]

Another way:

	A​	B​	C​	D​	E​	F​	G​	H​	I​
2​	1​	6​	13​	10​	19​	2​	12​	16​	A2: =RANDBETWEEN(1, 20)
3​	-1​	-3​	-9​	-8​	-15​	-2​	-11​	-8​	A3: =-RANDBETWEEN(1, A2)

 

[second grade parent]

Another way:

	A​	B​	C​	D​	E​	F​	G​	H​	I​
2​	1​	6​	13​	10​	19​	2​	12​	16​	A2: =RANDBETWEEN(1, 20)
3​	-1​	-3​	-9​	-8​	-15​	-2​	-11​	-8​	A3: =-RANDBETWEEN(1, A2)

<tbody>
</tbody>

I like what you did there incorporating A2. i was trying to avoid negatives so I will delete that part.

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[second grade parent]

18	10	8
13	1	12
5	9

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[second grade parent]

=+RANDBETWEEN(12,20)	=+RANDBETWEEN(1,A1)	=+A1-B1
=+RANDBETWEEN(1,A1)	=ROUNDDOWN(RAND()*B1,0)	=+A2-B2
=+A1-A2	=+B1-B2
Find the difference that solves for the blank

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[second grade parent]

A1 & B2 are blank (i color the font white so they can't see it)

 

[shg]

i was trying to avoid negatives so I will delete that part.

There are no negative answers.

 

[billfinn]

I did these in Addition, subtraction and Multiplication for my grandsons. I'll try to locate it tonight when I get home and post them up
Bill

 

[second grade parent]

a3: =-randbetween(1, a2)
doesn't that generate a negative?