Prev: inserting a default photo
Next: Text not appearing in webpage
From: clacount on 29 Mar 2010 17:18
Sorry, I must have clicked on the FrontPage tab rather than Excel and didn't
notice what I had done. Thanks for the response.

--
clacount


"LD55ZRA" wrote:

>
> 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: Helpful person on 29 Mar 2010 17:17
On Mar 29, 12:51 pm, clacount <claco...(a)discussions.microsoft.com>
wrote:
> Can someone tell me what a " mark in this formula means?
>
> Example: =IF(G40:G52)>0,SUM(G40:G52),"")
> --
> clacount

It is not an empty string as others have stated. It is a cell with
nothing in it which Excel treats differently to empty. You can check
this with the isempty (sp?) query.

www.richardfisher.com
First  |  Prev  | 
Pages: 1 2
Prev: inserting a default photo
Next: Text not appearing in webpage