| 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? I tried =lookup("x",a2:c2,{4,8,15}), but it displayed NA Does anyone have any help? Thank you -- Have a great day! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
see your previous post
-- 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? I tried =lookup("x",a2:c2,{4,8,15}), but it displayed NA Does anyone have any help? Thank you -- Have a great day! |
|
#3
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: see your previous post -- 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? I tried =lookup("x",a2:c2,{4,8,15}), but it displayed NA Does anyone have any help? Thank you -- Have a great day! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
Thank you!!!!! It worked!!!!!
-- Have a great day! "Marcelo" wrote: see your previous post -- 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? I tried =lookup("x",a2:c2,{4,8,15}), but it displayed NA Does anyone have any help? Thank you -- Have a great day! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting text to numbers
thanks for the feedback
-- regards from Brazil Thanks in advance for your feedback. Marcelo "northerner" escreveu: Thank you!!!!! It worked!!!!! -- Have a great day! "Marcelo" wrote: see your previous post -- 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? I tried =lookup("x",a2:c2,{4,8,15}), but it displayed NA Does anyone have any help? Thank you -- 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 | Excel Discussion (Misc queries) | |||
| Converting numbers to text | Excel Discussion (Misc queries) | |||
| 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) | |||
Hybrid Mode
