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
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 have in B1, but it always returns a #NULL error.
=IF(OR(ISERROR(A1),A1="---"),"NA",IF(A1
