Welcome Guest
You last visited May 24, 2017, 12:10 am
All times shown are
Eastern Time (GMT-5:00)

# formula for spead sheet excell

Topic closed. 7 replies. Last post 10 years ago by Raven62.

 Page 1 of 1
Mount Morris
United States
Member #46750
September 27, 2006
156 Posts
Offline
 Posted: January 14, 2007, 11:09 am - IP Logged

I am wanting to put 4 digit in it  4567  and then devide it by square root .to get answer

6757958271 so I can back test Nbey6 system faster it had the 808 last night st here in Mi

United States
Member #33295
February 19, 2006
699 Posts
Offline
 Posted: January 14, 2007, 4:48 pm - IP Logged

I am wanting to put 4 digit in it  4567  and then devide it by square root .to get answer

6757958271 so I can back test Nbey6 system faster it had the 808 last night st here in Mi

If 4567 is in cell A1 enter

=SQRT(A1)  in cell A2 or whatever cell you want it in.

And if 4567 is in a different cell replace (A1) with that cell number.

Isabel, you are going to feel very silly when this turns out to be make-believe.

United States
Member #41846
June 23, 2006
462 Posts
Offline
 Posted: January 14, 2007, 4:48 pm - IP Logged

hillbilly

assume your number is in a1   now format b1 to be # of character you want in this case 8

in cell b1  enter this formula   =int(sqrt(a1)*1000000)

you should have a 8 digit number no decimal

in cell c1   =left(b1,3)

in cell d1   =right(b1,3)

c1 and d1 have you numbers

some of these steps could be combined but this way you can see the steps

p8

Pennsylvania
United States
Member #2218
September 1, 2003
5473 Posts
Offline
 Posted: January 15, 2007, 10:57 am - IP Logged

hillbilly

assume your number is in a1   now format b1 to be # of character you want in this case 8

in cell b1  enter this formula   =int(sqrt(a1)*1000000)

you should have a 8 digit number no decimal

in cell c1   =left(b1,3)

in cell d1   =right(b1,3)

c1 and d1 have you numbers

some of these steps could be combined but this way you can see the steps

p8

Links to Pick 3 and Pick 4 Square Root Conversion Charts

I'm not sure if all the conversions are correct.

http://rapidshare.com/files/11831779/P3_and_P4_SQRT_Conversions.xls

http://rapidshare.com/files/11831967/Pick_3_SQRT.txt

http://rapidshare.com/files/11831968/Pick_4_SQRT.txt

New Jersey
United States
Member #17843
June 28, 2005
58070 Posts
Offline
 Posted: January 15, 2007, 2:33 pm - IP Logged

Links to Pick 3 and Pick 4 Square Root Conversion Charts

I'm not sure if all the conversions are correct.

http://rapidshare.com/files/11831779/P3_and_P4_SQRT_Conversions.xls

http://rapidshare.com/files/11831967/Pick_3_SQRT.txt

http://rapidshare.com/files/11831968/Pick_4_SQRT.txt

WSLS,

The 2 text files are the same: Are they suppose to be?

A mind once stretched by a new idea never returns to its original dimensions!

Pennsylvania
United States
Member #2218
September 1, 2003
5473 Posts
Offline
 Posted: January 16, 2007, 6:02 am - IP Logged

WSLS,

The 2 text files are the same: Are they suppose to be?

I'll correct them today.

Sorry!!

Pennsylvania
United States
Member #2218
September 1, 2003
5473 Posts
Offline
 Posted: January 16, 2007, 9:11 am - IP Logged

http://rapidshare.com/files/11965403/Pick_3_SQRT.txt

New Jersey
United States
Member #17843
June 28, 2005
58070 Posts
Offline
 Posted: January 16, 2007, 9:27 am - IP Logged