Help

How to perform function Replace if condition is met?

828 2
cancel
Showing results for 
Search instead for 
Did you mean: 
NEF1QLSZ4U
6 - Interface Innovator
6 - Interface Innovator

How to perform function Replace if condition is met?

2 Replies 2

Are 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?

ReplaceValueIFConciitionIsMet.jpg

 

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?