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?
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),IFERROR(MID(R167,SEARCH("p=",R167)+2,SEARCH("&",R167)-SEARCH("p=",R167)-2),IFERROR(RIGHT(R167,LEN(R167)-FIND("q=",R167)-1),IFERROR(RIGHT(R167,LEN(R167)-FIND("p=",R167)-1),zzzzzz))))
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments