If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One column to another
I am looking to make a number equal from one cell to another number. EX:
43=1, 42=2, 41=3, etc. going 43 to 1. here is how i have done it so far: =IF(C13=43,"1",IF(C13=42,"2", IF(C13=41,"3",IF(C13=40,"4",IF(C13=39,"5",IF(C13=3 8,"6", IF(C13=37,"7",IF(C13=36,"8")))))))) I have used 6 cells to complete it and I know that is not the best way to do it. |
#2
|
|||
|
|||
One column to another
Setup a table somewhere with all the possible combinations. It can be on
another sheet, and for this example, we'll say that is Sheet2, with your C13 cell back on Sheet1. On Sheet2: A B 1 43 1 2 42 2 3 43 3 4 39 5 5 38 6 continue as needed on down sheet 2 (and yes, I know I left out some pairs). For the example below, I will assume that the list ends at row 43. Then where you have your nested if formula you could use VLOOKUP() instead: =VLOOKUP(C13,Sheet2!$A$1:$B$43,2,False) "Make one column equal to another number" wrote: I am looking to make a number equal from one cell to another number. EX: 43=1, 42=2, 41=3, etc. going 43 to 1. here is how i have done it so far: =IF(C13=43,"1",IF(C13=42,"2", IF(C13=41,"3",IF(C13=40,"4",IF(C13=39,"5",IF(C13=3 8,"6", IF(C13=37,"7",IF(C13=36,"8")))))))) I have used 6 cells to complete it and I know that is not the best way to do it. |
#3
|
|||
|
|||
One column to another
Hi
Perhaps you could use =ABS(C13-44) -- Regards Roger Govier Make one column equal to another number wrote: I am looking to make a number equal from one cell to another number. EX: 43=1, 42=2, 41=3, etc. going 43 to 1. here is how i have done it so far: =IF(C13=43,"1",IF(C13=42,"2", IF(C13=41,"3",IF(C13=40,"4",IF(C13=39,"5",IF(C13=3 8,"6", IF(C13=37,"7",IF(C13=36,"8")))))))) I have used 6 cells to complete it and I know that is not the best way to do it. |
Thread Tools | |
Display Modes | |
|
|