Welcome Guest
You last visited December 8, 2016, 10:57 am
All times shown are
Eastern Time (GMT-5:00)

# Excell 07 sheet to see how much you have won NC Cash 5

Topic closed. Posted 7 years ago. No replies.

 Page 1 of 1
Iron Station, NC
United States
Member #74828
May 21, 2009
69 Posts
Offline
 Posted: September 19, 2009, 3:51 pm - IP Logged

Enter this formula in cell H7 =IF(\$H\$6=\$C7,1,IF(\$H\$6=\$D7,1,IF(\$H\$6=\$E7,1,IF(\$H\$6=\$F7,1,IF(\$H\$6=\$G7,1,".")))))

Enter this formula in Cell I7 =IF(\$I\$6=\$C7,1,IF(\$I\$6=\$D7,1,IF(\$I\$6=\$E7,1,IF(\$I\$6=\$F7,1,IF(\$I\$6=\$G7,1,".")))))

Enter this formula in Cell J7 . =IF(\$J\$6=\$C7,1,IF(\$J\$6=\$D7,1,IF(\$J\$6=\$E7,1,IF(\$J\$6=\$F7,1,IF(\$J\$6=\$G7,1,".")))))

Enter this formula in Cell K7 =IF(\$K\$6=\$C7,1,IF(\$K\$6=\$D7,1,IF(\$K\$6=\$E7,1,IF(\$K\$6=\$F7,1,IF(\$K\$6=\$G7,1,".")))))

Enter this formula in cell L7 =IF(\$L\$6=\$C7,1,IF(\$L\$6=\$D7,1,IF(\$L\$6=\$E7,1,IF(\$L\$6=\$F7,1,IF(\$L\$6=\$G7,1,".")))))

Enter this formula in Cell M7 =COUNTIF(H7:L7,1)

Enter this formula in Cell N7  =VLOOKUP(M7,\$Q\$4:\$R\$7,2)
copy this formula’s down as many cells as you want.

Copy this or make it in your Excel sheet in cell B4

Cash 5

H5

I5

J5

K5

L5

M5

N5

Enter winning numbers here

1st

2nd

3rd

4th

5th

Cell C6

1st

2nd

3rd

4th

5th

13

23

26

25

38

# U Hit

U Won

 Enter Your

1

7

16

25

38

.

.

.

1

1

2

\$1.00

Numbers Here

13

23

26

37

39

1

1

1

.

.

3

\$3.00

13

23

26

25

38

1

1

1

1

1

5

JP

Copy or make this in cell Q3                                                                                      Copy formula’s down as many cell as you wish

 Match Winning 2 \$1 3 \$3 4 \$351 5 JP

The winning amounts change each day as the JP gets rolled over each day.

 Page 1 of 1