Hi I am trying to do an iserror formula but am getting an error?

Could you please help.

The formula is:

=IF(ISERROR(A1="TEXT",A2,A3),"",(A1="TEXT",A2,A3))

Regards

M

What exactly are you trying to accomplish? Perhaps you could provide a
narrative description?

You are currently getting an error because ISERROR only takes one argument.
Writing ISERROR(A1="TEXT",A2,A3) puts three arguments into ISERROR, and it
doesn't know what you are trying to do.

Ex:
=ISERROR(A1/B1) would return TRUE if B1 is empty or contains a 0. Otherwise
is it would return FALSE.
=IF(ISERROR(A1/B1),"",A1/B1) would make the formula cell look blank if the
the division returned an error and perform the division if it didn't.

Please provide a little more detail.

tj



"Walshy" wrote:

Hi I am trying to do an iserror formula but am getting an error?

Could you please help.

The formula is:

=IF(ISERROR(A1="TEXT",A2,A3),"",(A1="TEXT",A2,A3))

Regards

M

Guessing, but

=IF(ISERROR(IF(A1="TEXT",A2,A3)),"",(IF(A1="TEXT", A2,A3)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Walshy" wrote in message
...
Hi I am trying to do an iserror formula but am getting an error?

Could you please help.

The formula is:

=IF(ISERROR(A1="TEXT",A2,A3),"",(A1="TEXT",A2,A3))

Regards

M

Just another guess:

=IF(ISERROR(A1),"",IF(A1="Text",A2,A3))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Walshy" wrote in message
...
Hi I am trying to do an iserror formula but am getting an error?

Could you please help.

The formula is:

=IF(ISERROR(A1="TEXT",A2,A3),"",(A1="TEXT",A2,A3))

Regards

M