On Thursday, July 19, 2012 9:56:29 AM UTC-4, Claus Busch wrote:
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

Ok, got it to result a number now, however the # is 1. In what I have set up, it should be 25,000.