From: clacount on 29 Mar 2010 15:51 Can someone tell me what a " mark in this formula means? Example: =IF(G40:G52)>0,SUM(G40:G52),"") -- clacount
From: Tom Willett on 29 Mar 2010 16:03 Where in FrontPage are you doing this? -- Tom [Pepper] Willett Microsoft MVP - FrontPage Since 1997 --------------------------- "clacount" <clacount(a)discussions.microsoft.com> wrote in message news:A43C132B-76C3-4B43-862A-6A36718E9E08(a)microsoft.com... : Can someone tell me what a " mark in this formula means? : : Example: =IF(G40:G52)>0,SUM(G40:G52),"") : -- : clacount
From: Ronx on 29 Mar 2010 16:06 Nothing to do with FrontPage, but if written correctly as =IF(SUM(G40:G52)>0,SUM(G40:G52),"") the expression means: If the sum of the values in the cells G40 through G52 is more than 0, then display that value, otherwise display an empty string ("" appears as blank cell). An Excel newsgroup or forum is a better place for this type of question. -- Ron Symonds Microsoft MVP (Expression Web) http://www.rxs-enterprises.org/fp Reply only to group - emails will be deleted unread. "clacount" <clacount(a)discussions.microsoft.com> wrote in message news:A43C132B-76C3-4B43-862A-6A36718E9E08(a)microsoft.com... > Can someone tell me what a " mark in this formula means? > > Example: =IF(G40:G52)>0,SUM(G40:G52),"") > -- > clacount
From: LD55ZRA on 29 Mar 2010 16:07 It means nothing or zero. The formula says that if CELLS G40 TO G52 contains numbers greater than 0, than find total of them else just enter nothing or zero. Is this anything to do with FP? I have only used such formulas in Excel but in FP you may want to use JavaScript. Please let us know. hth clacount wrote: > > Can someone tell me what a " mark in this formula means? > > Example: =IF(G40:G52)>0,SUM(G40:G52),"") > -- > clacount
From: clacount on 29 Mar 2010 17:17
Sorry, must have clicked off Excel tab and on FrontPage without realizing it. Thanks for the info. -- clacount "Ronx" wrote: > Nothing to do with FrontPage, but if written correctly as > =IF(SUM(G40:G52)>0,SUM(G40:G52),"") > the expression means: > If the sum of the values in the cells G40 through G52 is more than 0, then > display that value, otherwise display an empty string ("" appears as blank > cell). > > An Excel newsgroup or forum is a better place for this type of question. > -- > Ron Symonds > Microsoft MVP (Expression Web) > http://www.rxs-enterprises.org/fp > > Reply only to group - emails will be deleted unread. > > > > "clacount" <clacount(a)discussions.microsoft.com> wrote in message > news:A43C132B-76C3-4B43-862A-6A36718E9E08(a)microsoft.com... > > Can someone tell me what a " mark in this formula means? > > > > Example: =IF(G40:G52)>0,SUM(G40:G52),"") > > -- > > clacount > > . > |