View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Choose function gives different results from different cells?????

Your problem is intriguing, but without your formula it'll be difficult to
give you meaningful help.


***********
Regards,
Ron

XL2002, WinXP-Pro


"Dan @united_brokers" wrote:

I have a formula that contains a choose function with absolute cell
references. When I copy and paste this formula to other cells some result in
true, some in false and some in a Value error. The one place I really need
it to work it always resolves to a value error. What is causing this?