Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statement?
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: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=536799 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statement?
=CHOOSE(A1+1,5,6,7,8,9,0,1,2,3,4)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "tenaj" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=536799 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statement?
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: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=536799 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statement?
Bob Phillips Wrote: =CHOOSE(A1+1,5,6,7,8,9,0,1,2,3,4) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tenaj" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=536799 Thank You Bob Phillips! Superb!!!!!!!!!! I could have never figured that out. -- tenaj ------------------------------------------------------------------------ tenaj's Profile: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=536799 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If Statement?
Ron Coderre Wrote: Tenaj I think this does what you want: For a value in A1 B1: =MOD(A1+5,10) Does that help? Regards, 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: http://www.excelforum.com/member.php...o&userid=32691 View this thread: http://www.excelforum.com/showthread...hreadid=536799 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |