software

HI everyone. Newbie here. I have an easy question.lol I hope it is
easy but it is hard for me. I know how to do very basic excel
formulas, however this one threw me for a loop. =SUM(A1-1)

5 - A1
4
3
2
1
0
how do I tell it to subtract from 10 rather than one it should
continue
9
8
7
6
5
I need for it to wrap back to A-1

I will use 4 digits (cells) and enter different numbers and the first
one can be 0. If I enter 1234 in cells A1,B1,C1,D1 these should be the
result. I used some if statements but it didn't work.

Example

1234
0123
9012
8901
7890
6789
5678
4567
3456
2345
1234

Thanks for your help.

tenaj--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=525094Hi!

A......B......C......D
1.......2......3.......4

Enter this formula in A2 and copy across to D2:

=IF(A1=0,9,A1-1)

Then select A22 and copy down as needed.

Biff

quot;tenajquot; gt; wrote in
message ...
gt;
gt; HI everyone. Newbie here. I have an easy question.lol I hope it is
gt; easy but it is hard for me. I know how to do very basic excel
gt; formulas, however this one threw me for a loop. =SUM(A1-1)
gt;
gt; 5 - A1
gt; 4
gt; 3
gt; 2
gt; 1
gt; 0
gt; how do I tell it to subtract from 10 rather than one it should
gt; continue
gt; 9
gt; 8
gt; 7
gt; 6
gt; 5
gt; I need for it to wrap back to A-1
gt;
gt; I will use 4 digits (cells) and enter different numbers and the first
gt; one can be 0. If I enter 1234 in cells A1,B1,C1,D1 these should be the
gt; result. I used some if statements but it didn't work.
gt;
gt; Example
gt;
gt; 1234
gt; 0123
gt; 9012
gt; 8901
gt; 7890
gt; 6789
gt; 5678
gt; 4567
gt; 3456
gt; 2345
gt; 1234
gt;
gt; Thanks for your help.
gt;
gt; tenaj
gt;
gt;
gt; --
gt; tenaj
gt; ------------------------------------------------------------------------
gt; tenaj's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32691
gt; View this thread: www.excelforum.com/showthread...hreadid=525094
gt;
One way:

A2: =MOD(A1-1,10)

Copy across and down as required.

In article gt;,
tenaj gt; wrote:

gt; HI everyone. Newbie here. I have an easy question.lol I hope it is
gt; easy but it is hard for me. I know how to do very basic excel
gt; formulas, however this one threw me for a loop. =SUM(A1-1)
gt;
gt; 5 - A1
gt; 4
gt; 3
gt; 2
gt; 1
gt; 0
gt; how do I tell it to subtract from 10 rather than one it should
gt; continue
gt; 9
gt; 8
gt; 7
gt; 6
gt; 5
gt; I need for it to wrap back to A-1
gt;
gt; I will use 4 digits (cells) and enter different numbers and the first
gt; one can be 0. If I enter 1234 in cells A1,B1,C1,D1 these should be the
gt; result. I used some if statements but it didn't work.
gt;
gt; Example
gt;
gt; 1234
gt; 0123
gt; 9012
gt; 8901
gt; 7890
gt; 6789
gt; 5678
gt; 4567
gt; 3456
gt; 2345
gt; 1234
gt;
gt; Thanks for your help.
gt;
gt; tenaj


Thank you guys for helping out.

I used this formula first, and got exactly what I asked for. Thank
you

=IF(A1=0,9,A1-1)

5555
4444
3333
2222
1111
0000
9999
8888
7777
6666
5555

However there are two sides and the right side is Subtract 1 first
number, subtract 2 second number, subtract 3 third number and subtract
4 second number. I copied the formula to the right side and just
changed the -1 to corresponding columns and this is what I got. Why
it's the same formula just in different cells. When you subtract 2,3
and 4 the If statement doesn't work. I would appreciate any help you
can give me.

5555
4321
31-1-3
2-1-4-7
1-3-7-11
0-5-10-15
9-7-13-19
8-9-16-23
7-11-19-27
6-13-22-31
5-15-25-35--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=525094Not sure I understand what you want but try this modified version of JE's
formula:

=MOD(A1-COLUMNS($A:A),10)

Copy across then down.

Will return this:

5555
4321
3197
2963
1739
0505
9371
8147
7913
6789
5555Biff

quot;tenajquot; gt; wrote in
message ...
gt;
gt; Thank you guys for helping out.
gt;
gt; I used this formula first, and got exactly what I asked for. Thank
gt; you
gt;
gt; =IF(A1=0,9,A1-1)
gt;
gt; 5 5 5 5
gt; 4 4 4 4
gt; 3 3 3 3
gt; 2 2 2 2
gt; 1 1 1 1
gt; 0 0 0 0
gt; 9 9 9 9
gt; 8 8 8 8
gt; 7 7 7 7
gt; 6 6 6 6
gt; 5 5 5 5
gt;
gt; However there are two sides and the right side is Subtract 1 first
gt; number, subtract 2 second number, subtract 3 third number and subtract
gt; 4 second number. I copied the formula to the right side and just
gt; changed the -1 to corresponding columns and this is what I got. Why
gt; it's the same formula just in different cells. When you subtract 2,3
gt; and 4 the If statement doesn't work. I would appreciate any help you
gt; can give me.
gt;
gt; 5 5 5 5
gt; 4 3 2 1
gt; 3 1 -1 -3
gt; 2 -1 -4 -7
gt; 1 -3 -7 -11
gt; 0 -5 -10 -15
gt; 9 -7 -13 -19
gt; 8 -9 -16 -23
gt; 7 -11 -19 -27
gt; 6 -13 -22 -31
gt; 5 -15 -25 -35
gt;
gt;
gt; --
gt; tenaj
gt; ------------------------------------------------------------------------
gt; tenaj's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32691
gt; View this thread: www.excelforum.com/showthread...hreadid=525094
gt;

BLESS YOU! It works exactly.--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=525094
BLESS YOU! It works exactly.--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=525094
BLESS YOU! It works exactly.--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=525094