| 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 |
| 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 | |||
Threaded Mode
