| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting text to numbers
I have columns "A", "B", and "C". I want to place an "X" in only one of the
cells in the row below. If x is in column "A", it will =4. If x is in column "B", it will =8. If x is in column "C", it will =15. How do I create this formula so that whatever x equals, that number will be displayed in cell F2? Thanks in advance, -- Have a great day! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
Hi,
see if it helps you on F2 =lookup("x",a2:c2,{4,8,15}) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: I have columns "A", "B", and "C". I want to place an "X" in only one of the cells in the row below. If x is in column "A", it will =4. If x is in column "B", it will =8. If x is in column "C", it will =15. How do I create this formula so that whatever x equals, that number will be displayed in cell F2? Thanks in advance, -- Have a great day! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
Marcelo,
I tried that and it displays NA. Any other suggestions? -- Have a great day! "Marcelo" wrote: Hi, see if it helps you on F2 =lookup("x",a2:c2,{4,8,15}) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: I have columns "A", "B", and "C". I want to place an "X" in only one of the cells in the row below. If x is in column "A", it will =4. If x is in column "B", it will =8. If x is in column "C", it will =15. How do I create this formula so that whatever x equals, that number will be displayed in cell F2? Thanks in advance, -- Have a great day! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
shows NA if you do not have any X in a, b or c column, you can use
=if(iserror((lookup("x",a2:c2,{4,8,15}))),"",(look up("x",a2:c2,{4,8,15}))) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: Marcelo, I tried that and it displays NA. Any other suggestions? -- Have a great day! "Marcelo" wrote: Hi, see if it helps you on F2 =lookup("x",a2:c2,{4,8,15}) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: I have columns "A", "B", and "C". I want to place an "X" in only one of the cells in the row below. If x is in column "A", it will =4. If x is in column "B", it will =8. If x is in column "C", it will =15. How do I create this formula so that whatever x equals, that number will be displayed in cell F2? Thanks in advance, -- Have a great day! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
shows NA if you do not have any X in a, b or c column, you can use
=if(iserror((lookup("x",a2:c2,{4,8,15}))),"",(look up("x",a2:c2,{4,8,15}))) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marcelo" escreveu: shows NA if you do not have any X in a, b or c column, you can use =if(iserror((lookup("x",a2:c2,{4,8,15}))),"",(look up("x",a2:c2,{4,8,15}))) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: Marcelo, I tried that and it displays NA. Any other suggestions? -- Have a great day! "Marcelo" wrote: Hi, see if it helps you on F2 =lookup("x",a2:c2,{4,8,15}) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: I have columns "A", "B", and "C". I want to place an "X" in only one of the cells in the row below. If x is in column "A", it will =4. If x is in column "B", it will =8. If x is in column "C", it will =15. How do I create this formula so that whatever x equals, that number will be displayed in cell F2? Thanks in advance, -- Have a great day! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting text to numbers | Excel Worksheet Functions | |||
| converting numbers to text | New Users to Excel | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
| Converting text to numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
