IF statement

[Bwangster12]

I currently have a formula that is REPLACING some characters in a URL with characters found in another column.

Ex... www.google.com/keycode:XXXX (Column A) and this becomes in column B: www.google.com/keycode: 123456 (123456 found in column D)

What I need to do is have the cell in column B populate with "Use Landing Page URL Generator Tool" IF the column that has the URL (column A from example) says "Use Landing Page URL Generator Tool."


=IF(K478="Use Landing Page URL Generator Tool", "Use Landing Page URL Generator Tool", "IF(ISNA(REPLACE(K477,75,4,A477)),"",REPLACE(K477,75,4,A477))")

This formula does what I want, but if the cell has a URL in it, and not "Use Landing Page URL Generator Tool," then it just puts "IF(ISNA(REPLACE(K477,75,4,A477)),",REPLACE(K477,75,4,A477))"

How do I get it to do that formula and not just type "IF(ISNA(REPLACE(K477,75,4,A477)),",REPLACE(K477,75,4,A477))" in the cell?

[olasa]

First, I think there is an case missing:

Cases:
1: cell = "Use Landing Page URL Generator Tool." --> "Use Landing Page URL Generator Tool."
2: cell = NOT("Use Landing Page URL Generator Tool.") --> "IF(ISNA(REPLACE(K477,75,4,A477)),"",REPLACE(K477,75,4,A477))"
3: cell = AND(NOT("Use Landing Page URL Generator Tool."),url in cell) --> what should the formula result be?
4: cell = AND("Use Landing Page URL Generator Tool."),url in cell) ... as I understand this is never the case

Second, there is a formula named =HYPERLINK() but there is no formula - like =ISHYPERLINK() - that checks for hyperlinks .
To check for hyperlinks you will need some VBA code. Post a question in the Programming forum - for best response.

//Ola

[Bwangster12]

Well, your reply is a bit over my head unfortunately.

My question is... is there a way to return a preset value (Use Landing Page URL Generator Tool) if another cell returns a value of X (In this case "Use Landing Page URL Generator Tool)?

My column K is VLOOKUP the contents of column in another sheet and returning the "URL" or the "Use Landing Page URL Generator Tool" value. Is there then a way to have column L do the formula I have correctly working to replace some characters:

=IF(ISNA(REPLACE(K476,75,4,A476)),"",REPLACE(K476,75,4,A476))

Or if the value in that column K is "Use Landing Page URL Generator Tool" instead of a URL just have it repeat "Use Landing Page URL Generator Tool" in column L?

[olasa]

Sorry I don't understand what you want.

"My question is... is there a way to return a preset value (Use Landing Page URL Generator Tool) if another cell returns a value of X (In this case "Use Landing Page URL Generator Tool)?"

Maybe someone else does, or you could try and attach a sample file.

//Ola