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