How to use different formula in case of en error?

rockyraw

I want to run the following formulas on a cell, in this order, in case the previous formula returns an error.

=MID(P2,SEARCH("q=",P2)+2,SEARCH("&",P2)-SEARCH("q=",P2)-2)

=MID(P2,SEARCH("p=",P2)+2,SEARCH("&",P2)-SEARCH("p=",P2)-2)

=RIGHT(P2,LEN(P2)-FIND("q=",P2)-1)

=RIGHT(P2,LEN(P2)-FIND("p=",P2)-1)

How can I define this?

rockyraw

I've manged to do it with multiple IFERROR inside an IFERORR:

=IFERROR(MID(R167,SEARCH("q=",R167)+2,SEARCH("&",R167)-SEARCH("q=",R167)-2),IFE‌​RROR(MID(R167,SEARCH("p=",R167)+2,SEARCH("&",R167)-SEARCH("p=",R167)-2),IFERROR(R‌​IGHT(R167,LEN(R167)-FIND("q=",R167)-1),IFERROR(RIGHT(R167,LEN(R167)-FIND("p=",R16‌​7)-1),zzzzzz))))

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

How to calculate an formula in a different timeframe

From Dev

How to use different error codes for validation messages?

From Dev

Use date values from different sheet in formula

From Dev

Unable to use the same formula for different rows in excel

From Dev

Use date values from different sheet in formula

From Dev

Excel if blank cell use different cell in formula

From Dev

same case value but run different formula if first character is

From Dev

how to use different distance formula other than euclidean distance in k means

From Dev

How can I use a formula to match multiple criteria from a different table in Excel?

From Dev

How to use @Formula in Hibernate/JPA

From Dev

How to use OneToOne with Hibernate Formula

From Dev

How to use a calculated name in a formula

From Dev

How to use Command Line Parser Library in case Error happend?

From Dev

How to use Command Line Parser Library in case Error happend?

From Dev

How to use Case-When and Update in Trigger?(Error in my code)

From Dev

How to use decltype in this case

From Dev

How to use struct in this case

From Dev

How to use Case in SQL?

From Dev

How to use a functional in this case?

From Dev

How use case with findwindow

From Dev

How to use mocking in this case?

From Dev

How to use case here

From Dev

How to use lastInsertId in this case?

From Dev

sql how to use case?

From Dev

How to use CASE in MySQL?

From Dev

How to use case with in operator

From Dev

How to use reduce in this case?

From Dev

How to use mocking in this case?

From Dev

How to use decltype in this case