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