need help with excel

Reply #5

Mickie — Sat, 28 Mar 2009 12:32:47 GMT

Easy:

A1 2479

B1 =MID($A1,1,1)+MID($A1,2,1)+MID($A1,3,1)+MID($A1,4,1)

C1 =MOD(SUM(MID($B1,1,1)+MID($B1,2,1)),10)

A1 B1 C1

2479 22 4

or send me your sheet, I will fix it the way you want. I have office 2003.

Have a good day

Mickie

Reply #4

denn0n — Fri, 27 Mar 2009 16:30:51 GMT

hey hillbilly953,

1. If H2 Cell contains 2470

2. Format H2 as Text

3. Key in this formula in I2

=IF(LEN(H2=4);SUM(VALUE(MID(H2;1;1));VALUE(MID(H2;2;1));VALUE(MID(H2;3;1));VALUE(MID(H2;4;1)));SUM(VALUE(MID(H5;1;1));VALUE(MID(H5;2;1));VALUE(MID(H5;3;1))))

(I am using Open Office)

4. Result should get in I2 is 13

5. You could have another column doing 1+3=4 say as Cell J2

IF(LEN(i2=2);SUM(VALUE(MID(I2;1;1));VALUE(MID(i2;2;1)));SUM(VALUE(MID(i2;1;1));VALUE(MID(i2;2;1));VALUE

Reply #3

hillbilly953 — Fri, 27 Mar 2009 14:20:00 GMT

Mickie that formula you posted works for me . Thanks

now see what curious2k3 posted it want work for me .

problem --- 2479=22 sum == sum-4 iam trying to do all automatic with out typing in each digit to break it down using lottery math so when I get my xl done i can let people use it to see how it works in there state. lot of older people don't know where to put the numbers in

type in 4 digit 2479 = 4 may not be able to do it these way.

Reply #2

Mickie — Fri, 27 Mar 2009 13:57:37 GMT

Say your number is 2698742563.2

Put it in A1, then in A2 put in this formula:

=MID($A$1,1,1) and it will give you 2

$A$1 is the cell your long number is

,1 is the position you want extracting (1st digit)

,1 is how many digits you want extracted.

For example: =MID($A$1,1,3) you would get 269

=MID($A$1,3,3) you would get 987

Hope this helps

Mickie

Reply #1

Curious2k3 — Fri, 27 Mar 2009 02:14:28 GMT

Try the following, breaking each number apart.

need help with excel

hillbilly953 — Thu, 26 Mar 2009 23:57:25 GMT

1: I need to see how to make formula for one cell like 25= 7 63=9 64=0

2: i want to break done a string of numbers like 2698742563.2 but i only want some of them say 8 ,2,6

and the string is in one cell but need to put my pick in another cell for testing faster