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