software

Hey everyone,

=IF(A1=0,9,A1-1)
This formulas says if A1=0, make it 9 and subtract 1

How do I make it say if A1 equals 0, make A2= 5 and if A1=5 make A2=0

But there are 5 conditions. They mirror each other. Example: a 0 is a
5 and a 5 is a 0.

0=5, 5=0
1= 6, 6=1
2=7, 7=2
3=8, 8=3
4=9, 9=4
How do I make the cell meet all of these conditions.

Thank you for your help.--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=536799=CHOOSE(A1 1,5,6,7,8,9,0,1,2,3,4)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;tenajquot; gt; wrote in
message ...
gt;
gt; Hey everyone,
gt;
gt; =IF(A1=0,9,A1-1)
gt; This formulas says if A1=0, make it 9 and subtract 1
gt;
gt; How do I make it say if A1 equals 0, make A2= 5 and if A1=5 make A2=0
gt;
gt; But there are 5 conditions. They mirror each other. Example: a 0 is a
gt; 5 and a 5 is a 0.
gt;
gt; 0=5, 5=0
gt; 1= 6, 6=1
gt; 2=7, 7=2
gt; 3=8, 8=3
gt; 4=9, 9=4
gt; How do I make the cell meet all of these conditions.
gt;
gt; Thank you for your help.
gt;
gt;
gt; --
gt; tenaj
gt; ------------------------------------------------------------------------
gt; tenaj's Profile:
www.excelforum.com/member.php...oamp;userid=32691
gt; View this thread: www.excelforum.com/showthread...hreadid=536799
gt;

Tenaj

I think this does what you want:

For a value in A1

B1: =MOD(A1 5,10)

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=536799
Bob Phillips Wrote:
gt; =CHOOSE(A1 1,5,6,7,8,9,0,1,2,3,4)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;tenajquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hey everyone,
gt; gt;
gt; gt; =IF(A1=0,9,A1-1)
gt; gt; This formulas says if A1=0, make it 9 and subtract 1
gt; gt;
gt; gt; How do I make it say if A1 equals 0, make A2= 5 and if A1=5 make
gt; A2=0
gt; gt;
gt; gt; But there are 5 conditions. They mirror each other. Example: a 0 is
gt; a
gt; gt; 5 and a 5 is a 0.
gt; gt;
gt; gt; 0=5, 5=0
gt; gt; 1= 6, 6=1
gt; gt; 2=7, 7=2
gt; gt; 3=8, 8=3
gt; gt; 4=9, 9=4
gt; gt; How do I make the cell meet all of these conditions.
gt; gt;
gt; gt; Thank you for your help.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; tenaj
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; tenaj's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32691
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=536799
gt; gt;
Thank You Bob Phillips! Superb!!!!!!!!!! I could have never figured
that out.--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=536799
Ron Coderre Wrote:
gt; Tenaj
gt;
gt; I think this does what you want:
gt;
gt; For a value in A1
gt;
gt; B1: =MOD(A1 5,10)
gt;
gt; Does that help?
gt;
gt; Regards,
gt; Ron

Thank you Ron. I didn't figure out how to use it. Maybe I did
something wrong. The formula didn't generate anything but I have a
formula now that does exactly what I need. Thank you for you time and
help.--
tenaj
------------------------------------------------------------------------
tenaj's Profile: www.excelforum.com/member.php...oamp;userid=32691
View this thread: www.excelforum.com/showthread...hreadid=536799