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 |
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 |