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

# Excel Help

Topic closed. 10 replies. Last post 11 years ago by time*treat.

 Page 1 of 1
Clarksville
United States
Member #487
July 15, 2002
17638 Posts
Offline
 Posted: January 22, 2006, 2:06 pm - IP Logged

I need a formula that I can put into a cell in a chart that will add +1 to any number. Can anyone help?

If you know your number is going to hit, have patience and then KILL IT!

You never know when you will get another hit.

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: January 22, 2006, 2:21 pm - IP Logged

if your numbers are in individual columns (first digit in A1, second digit in B1, third digit in C1)

you could easily put the new numbers in E1,F1 and G1

simple, E1 enter  = A1+1

but, that will make a 9 a 10, since you probably want to avoid that,in E1 enter

=IF(A1+1>9,(A1-10)+1,(A1+1))

this adds a 1 to any number and if it'sa 9, makes it a zero...

(F1 would work on B1 and G1 would work on C1)

is that what you meant?

Playing more than one ticket per game is betting against yourself.

Clarksville
United States
Member #487
July 15, 2002
17638 Posts
Offline
 Posted: January 22, 2006, 3:48 pm - IP Logged

not exactly..say for instance a number hit 10 draws ago and I want for my chart to be able to count the draws since..

If you know your number is going to hit, have patience and then KILL IT!

You never know when you will get another hit.

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5912 Posts
Online
 Posted: January 22, 2006, 3:58 pm - IP Logged

LOL,

Are you looking for a formula to count the skips of each digit? I use the formula below.

Carbob

=IF(ISNUMBER(MATCH(H17,\$B\$9:\$B\$3314,0)),MATCH(H17,\$B\$9:\$B\$3314,0)-1,"")

 POS 1 HITS SKIPS 0 292 54 1 253 0 2 296 8 3 276 1 4 284 48

Clarksville
United States
Member #487
July 15, 2002
17638 Posts
Offline
 Posted: January 22, 2006, 4:50 pm - IP Logged

No..that is not it either..

 x 597 8/04 12 178 424* 3

I want a formula that will add +1 to 424 which is the draws out since this particular number hit.  Each day that goes by will add +1 to the draws already out.

If you know your number is going to hit, have patience and then KILL IT!

You never know when you will get another hit.

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: January 22, 2006, 7:42 pm - IP Logged

if 424 is in a cell (let's say F424), then cell F425 can be

=F425+1

what chart type are you using?

Playing more than one ticket per game is betting against yourself.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: January 22, 2006, 9:31 pm - IP Logged

No..that is not it either..

 x 597 8/04 12 178 424* 3

I want a formula that will add +1 to 424 which is the draws out since this particular number hit.  Each day that goes by will add +1 to the draws already out.

Is this for pick 3/pick 4 or what?

Are you speaking of a particular digit going by or a particular combo?

L ttaL   T

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: January 23, 2006, 11:52 am - IP Logged
 a b c d e 597 08/04/04 12 178 424*

let's say this is all in row 1.

replace 424* with =NOW()-B1

format E1 as a number (zero decimal places)

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: January 23, 2006, 12:49 pm - IP Logged

Now, it makes sense to me.

But shouldn't it be =Now()+B1 or am I confused again???

L ttaL   T

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: January 23, 2006, 6:17 pm - IP Logged

time*treat has the right idea..

the date by the number would represent the last appearance...

NOW() returns the date (and time.... time is to the right of the decimal so no decimal places eliminates it) for right now... so now()-B1 would be the time interval between the last match and right now...

it does work out... nice one t*t!

Playing more than one ticket per game is betting against yourself.

United States
Member #13130
March 30, 2005
2171 Posts
Offline
 Posted: January 23, 2006, 6:24 pm - IP Logged

Lotta,

eXceL internally treats dates as a number, each day being 1 higher than the previous day. So you take the day "Now" and subtract a smaller previous day to get the difference in days. Your formula will be useful once you get really good at predicting future drawings, though.

In neo-conned Amerika, bank robs you.
Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

 Page 1 of 1