ExcelBanter - Help! Newbie

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help! Newbie (https://www.excelbanter.com/excel-discussion-misc-queries/78827-help-newbie.html)

tenaj

Help! Newbie

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: http://www.excelforum.com/member.php...o&userid=32691
View this thread: http://www.excelforum.com/showthread...hreadid=525094

Biff

Help! Newbie

Hi!

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 A2:D2 and copy down as needed.

Biff

"tenaj" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=32691
View this thread: http://www.excelforum.com/showthread...hreadid=525094

JE McGimpsey

Help! Newbie

One way:

A2: =MOD(A1-1,10)

Copy across and down as required.

In article ,
tenaj wrote:

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

Help! Newbie

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)

5 5 5 5
4 4 4 4
3 3 3 3
2 2 2 2
1 1 1 1
0 0 0 0
9 9 9 9
8 8 8 8
7 7 7 7
6 6 6 6
5 5 5 5

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.

5 5 5 5
4 3 2 1
3 1 -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: http://www.excelforum.com/member.php...o&userid=32691
View this thread: http://www.excelforum.com/showthread...hreadid=525094

Biff

Help! Newbie

Not 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
5555

Biff

"tenaj" wrote in
message ...

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)

5 5 5 5
4 4 4 4
3 3 3 3
2 2 2 2
1 1 1 1
0 0 0 0
9 9 9 9
8 8 8 8
7 7 7 7
6 6 6 6
5 5 5 5

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.

5 5 5 5
4 3 2 1
3 1 -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:
http://www.excelforum.com/member.php...o&userid=32691
View this thread: http://www.excelforum.com/showthread...hreadid=525094

tenaj

Help! Newbie

BLESS YOU!;) It works exactly.

--
tenaj
------------------------------------------------------------------------
tenaj's Profile: http://www.excelforum.com/member.php...o&userid=32691
View this thread: http://www.excelforum.com/showthread...hreadid=525094

tenaj

Help! Newbie

tenaj

Help! Newbie

All times are GMT +1. The time now is 08:31 AM.