| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function argument correct result but answer 0 in cell?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function argument correct result but answer 0 in cell?
I have no idea either. You didn't provide the data in the cells, the
function you're using and where you are using the function. My mind is tired tonight. No mind reading possible. Tyro "Tonzie" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function argument correct result but answer 0 in cell?
On Sun, 16 Mar 2008 20:04:01 -0700, 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. Yes, someone can explain that. I have an idea it could be something in the options It might be. Hard to tell based on the information you've provided so far. --ron |
|
#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 |
| Reply |
| 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) | |||
Linear Mode
