| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function details show value, but display shows #n/a
Here is my simple test formula:
=MATCH(TRUE,C18:E180,0) c18= 0 d18= 1 e18=2 The details of the fx show the following: Lookup-value= TRUE Lookup-array=(FALSE,TRUE,TRUE) match type=0 Formula result=2 ,which is the response I want. My sheet answer, however is #n/a while it should be 2. I don't know why. Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function details show value, but display shows #n/a
To make that formula work you need to indicate to Excel that an array is
being used. Try this: Edit the formula cell, but make no changes Commit that array formula by holding down the [Ctrl][Shift] keys when you press [Enter]. Excel will put curly braces { } around the formula and you should see the result you want. Note: you cannot just type in the braces...you have to let Excel put them in. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "mike" wrote: Here is my simple test formula: =MATCH(TRUE,C18:E180,0) c18= 0 d18= 1 e18=2 The details of the fx show the following: Lookup-value= TRUE Lookup-array=(FALSE,TRUE,TRUE) match type=0 Formula result=2 ,which is the response I want. My sheet answer, however is #n/a while it should be 2. I don't know why. Please help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function details show value, but display shows #n/a
Great and fast reply. Works exactly as suggested. Many thanks, Mike
"Ron Coderre" wrote: To make that formula work you need to indicate to Excel that an array is being used. Try this: Edit the formula cell, but make no changes Commit that array formula by holding down the [Ctrl][Shift] keys when you press [Enter]. Excel will put curly braces { } around the formula and you should see the result you want. Note: you cannot just type in the braces...you have to let Excel put them in. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "mike" wrote: Here is my simple test formula: =MATCH(TRUE,C18:E180,0) c18= 0 d18= 1 e18=2 The details of the fx show the following: Lookup-value= TRUE Lookup-array=(FALSE,TRUE,TRUE) match type=0 Formula result=2 ,which is the response I want. My sheet answer, however is #n/a while it should be 2. I don't know why. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Help with Formula,reulsts show in Function, not in Spreadsheet? | Excel Worksheet Functions | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
| in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
| Why does the formula result show a number but the screen shows ze. | Excel Worksheet Functions | |||
Linear Mode
