Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Divide Column A by Column B multiply Column C | Excel Worksheet Functions |