How to perform function Replace if condition is met?
How to perform function Replace if condition is met?
+7
+29Are you asking how to nest formula functions inside each other?
IF(
condition,
SUBSTITUTE( string, old_text, new_text)
)
Can you give an example of what you want?
+7Are you asking how to nest formula functions inside each other?
IF(
condition,
SUBSTITUTE( string, old_text, new_text)
)
Can you give an example of what you want?
If I use FILTER, it is not possible to add replacement. So, replacement is not like Excel. Should we use code inside another filed not FILTER?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.