Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2024 04:02 AM
How to perform function Replace if condition is met?
2 Replies 2

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2024 06:18 AM
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?
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 12, 2024 03:47 AM
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?
