Thread: Formula is correct, but result will not show
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Formula is correct, but result will not show
it gives me the proper formula, but the answer is just a
copy of the answer from the original formula

Sounds like calc is set to manual. Try pressing F9 to recalc. Does it
compute properly now? In xl03, click ToolsOptionsCalculation tab to re-set
calc mode to Auto. Maybe you could try equiv. steps in your xl07.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---

Reply With QuoteReply With Quote