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