From: clacount on
Can someone tell me what a " mark in this formula means?

Example: =IF(G40:G52)>0,SUM(G40:G52),"")
--
clacount
From: Tom Willett on
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
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

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
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
>
> .
>