If statement with iserror

[adam2308]

I have the following the forumula with just one if statement.

Please Login or Register  to view this content.

I also want to add in to the forumla (probably another if statment) which says if the false statement returns an iserror then to return "" in the cell. If the false statement does not return an iserror, then to return the original false statement.

Cheers,

[oldchippy]

Hi,

How about,

Please Login or Register  to view this content.

[ChemistB]

You can use an OR

Please Login or Register  to view this content.

If there is a specific part of your formulat that would be returning the error (e.g. your VLOOKUP), then you can just check that part of your formula inside the ISERROR.

[adam2308]

perfect - thank you! I was going down the same lines myself but kept messing up somewhere along the lines.

Cheers,