| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function argument correct result but answer 0 in cell?
My guess is that it is an array formula which just needs to be
"array-entered", ie try clicking inside the formula bar, then press CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tonzie" wrote: Can anyone explain why I get the correct answer in the Function argument but 0 (Zero) displayed as the result in the Cell. I have an idea it could be something in the options |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to Find the Correct Answer-But not using Vlookup Function | Excel Worksheet Functions | |||
| Trying to Find the Correct Answer-But not using Vlookup Function | Excel Worksheet Functions | |||
| Trying to Find the Correct Answer-But not using Vlookup Function | Excel Worksheet Functions | |||
| Using MATCH function does not return correct answer | Excel Worksheet Functions | |||
| A correct IF function doesn't show the function's result in cell | Excel Discussion (Misc queries) | |||
Threaded Mode
