[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: Please help - getting '#VALUE!" in Cells of 2nd sheet
From:       Rana Aich <ranaaich () yahoo ! com>
Date:       2006-08-24 20:03:13
Message-ID: 20060824200313.2289.qmail () web81911 ! mail ! mud ! yahoo ! com
[Download RAW message or body]

Thanks for your tips. Actually I went further and
found that the Formula that I'm using has COUNTIF. The
formula that gives me wrong result is as follows:

=COUNTIF(sheet1!E2:E183,"<=499")-COUNTIF(sheet1!E2:E183,"<200")

Whereas, I've tried a simple formula as below:
=SUM(sheet1!E2:E115) and Bingo! It is working. So it
seems I have done something wrong with the String
processing with "COUNTIF".

My "Calculation Tab" in "Tool>Option" is in Automatic
mode.

--- deshmol-lists@yahoo.com wrote:

> Check whether you have 
> 
>  Tools > Options > [calculations_tab] > Calculation 
> 
> ...set to "Automatic".
> 
> 
> Alternatively, you can also use
> F9/Shift+F9/Ctrl+Alt+F9/Ctrl+Alt+Shift+F9 to
> evaluate
> all changed formulae in the sheet (look up the excel
> help for details/differences of each key
> combination.
> 
> 
> ~ amol
> 
> --- Rana Aich <ranaaich@yahoo.com> wrote:
> 
> > Hi,
> > 
> > I'm generating an Excel File with two sheets :
> > Sheet1
> > and Sheet2. In Sheet1 I've calculated few formulas
> -
> > and they are working fine.
> > 
> > In the Sheet2 I put formulas based on values on
> > Sheet1. But instead of getting the Proper Values
> I'm
> > getting "#VALUE!" in all the cells. Interstingly
> > after
> > clicking the individual cells in Sheet2 and
> pressing
> > the "Enter" key, the Cell value is shown.
> > 
> > How can I obtain the proper values in the cells of
> > 2nd
> > sheet instead of "#VALUE!"?
> > 
> > Thanking you all in advance.
> > 
> > 
> > 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > poi-user-unsubscribe@jakarta.apache.org
> > Mailing List:    
> > http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: 
> > http://jakarta.apache.org/poi/
> > 
> > 
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> poi-user-unsubscribe@jakarta.apache.org
> Mailing List:    
> http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: 
> http://jakarta.apache.org/poi/
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

[prev in list] [next in list] [prev in thread] [next in thread]