Thread: Function argument correct result but answer 0 in cell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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 With QuoteReply With Quote