Thread
:
Formula Assistance
View Single Post
#
5
Posted to microsoft.public.excel.misc
Claus Busch
external usenet poster
Posts: 3,872
Formula Assistance
Hi,
Am Thu, 19 Jul 2012 06:49:27 -0700 (PDT) schrieb
:
I get "false" with this formula. When I hit CTRL+Shift+Enter it enters a "{" infront of the "=". Thoughts?
that's correct. When you hit CTRL+Shift+Enter you have to get "{" in
front and "}" behind the formula. The formula is an array formula.
Paste the formula into your cell, press F2 and then CTRL+Shift+Enter
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch