Welcome Guest
Log In | Register )
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
PrintE-mailLink
Avatar
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.