iserror

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

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)

 

[Ragdyer]

Just another guess:

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