Your formula is perfect. But the Calculation Options are set to "manual", so
you need to press F9 to calculate (or go to "calculation options" and check
"automatic")
Regards,
Bruno
On Wed, Sep 1, 2010 at 1:19 PM, Kurt wrote:
> Posted it to the file list. It's called ISERROR Example.xls.
>
>
> O
Posted it to the file list. It's called ISERROR Example.xls.
On Sep 1, 1:00 am, "C.G.Kumar" wrote:
> Kindly attach sample file.
>
> On Wed, Sep 1, 2010 at 12:12 AM, Kurt wrote:
> > Can't seem to get this working.
>
> > If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make
> > B1
Kindly attach sample file.
On Wed, Sep 1, 2010 at 12:12 AM, Kurt wrote:
> Can't seem to get this working.
>
> If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make
> B1 = "NA"
>
> Otherwise: If A1 < Y1, make B1 = "!", otherwise make B1 = "" (i.e.,
> blank).
>
> This is what I hav
