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:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][td="bgcolor:#C0C0C0"]

G​

[/td][td="bgcolor:#C0C0C0"]

H​

[/td][td="bgcolor:#C0C0C0"]

I​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

2​

[/td][td="bgcolor:#CCFFCC"]

1​

[/td][td="bgcolor:#CCFFCC"]

6​

[/td][td="bgcolor:#CCFFCC"]

13​

[/td][td="bgcolor:#CCFFCC"]

10​

[/td][td="bgcolor:#CCFFCC"]

19​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td="bgcolor:#CCFFCC"]

12​

[/td][td="bgcolor:#CCFFCC"]

16​

[/td][td="bgcolor:#CCFFCC"]A2: =RANDBETWEEN(1, 20)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td="bgcolor:#CCFFFF"]

-1​

[/td][td="bgcolor:#CCFFFF"]

-3​

[/td][td="bgcolor:#CCFFFF"]

-9​

[/td][td="bgcolor:#CCFFFF"]

-8​

[/td][td="bgcolor:#CCFFFF"]

-15​

[/td][td="bgcolor:#CCFFFF"]

-2​

[/td][td="bgcolor:#CCFFFF"]

-11​

[/td][td="bgcolor:#CCFFFF"]

-8​

[/td][td="bgcolor:#CCFFFF"]A3: =-RANDBETWEEN(1, A2)[/td][/tr]
[/table]

 

[second grade parent]

Another way:

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #C0C0C0"][/TD]
[TD="bgcolor: #C0C0C0"]

A​

[/TD]
[TD="bgcolor: #C0C0C0"]

B​

[/TD]
[TD="bgcolor: #C0C0C0"]

C​

[/TD]
[TD="bgcolor: #C0C0C0"]

D​

[/TD]
[TD="bgcolor: #C0C0C0"]

E​

[/TD]
[TD="bgcolor: #C0C0C0"]

F​

[/TD]
[TD="bgcolor: #C0C0C0"]

G​

[/TD]
[TD="bgcolor: #C0C0C0"]

H​

[/TD]
[TD="bgcolor: #C0C0C0"]

I​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

2​

[/TD]
[TD="bgcolor: #CCFFCC"]

1​

[/TD]
[TD="bgcolor: #CCFFCC"]

6​

[/TD]
[TD="bgcolor: #CCFFCC"]

13​

[/TD]
[TD="bgcolor: #CCFFCC"]

10​

[/TD]
[TD="bgcolor: #CCFFCC"]

19​

[/TD]
[TD="bgcolor: #CCFFCC"]

2​

[/TD]
[TD="bgcolor: #CCFFCC"]

12​

[/TD]
[TD="bgcolor: #CCFFCC"]

16​

[/TD]
[TD="bgcolor: #CCFFCC"]A2: =RANDBETWEEN(1, 20)[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

3​

[/TD]
[TD="bgcolor: #CCFFFF"]

-1​

[/TD]
[TD="bgcolor: #CCFFFF"]

-3​

[/TD]
[TD="bgcolor: #CCFFFF"]

-9​

[/TD]
[TD="bgcolor: #CCFFFF"]

-8​

[/TD]
[TD="bgcolor: #CCFFFF"]

-15​

[/TD]
[TD="bgcolor: #CCFFFF"]

-2​

[/TD]
[TD="bgcolor: #CCFFFF"]

-11​

[/TD]
[TD="bgcolor: #CCFFFF"]

-8​

[/TD]
[TD="bgcolor: #CCFFFF"]A3: =-RANDBETWEEN(1, A2)[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 216"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[second grade parent]

[TABLE="width: 216"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[second grade parent]

[TABLE="width: 664"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]=+RANDBETWEEN(12,20)[/TD]
[TD]=+RANDBETWEEN(1,A1)[/TD]
[TD]=+A1-B1[/TD]
[/TR]
[TR]
[TD]=+RANDBETWEEN(1,A1)[/TD]
[TD]=ROUNDDOWN(RAND()*B1,0)[/TD]
[TD]=+A2-B2[/TD]
[/TR]
[TR]
[TD]=+A1-A2[/TD]
[TD]=+B1-B2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Find the difference that solves for the blank[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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?