Hi,
You can't do this without a macro, but you could use a helper cell/column to derive the result, e.g.
HTH![]()
=IF(A2="y","-active-","active")
Hi,
You can't do this without a macro, but you could use a helper cell/column to derive the result, e.g.
HTH![]()
=IF(A2="y","-active-","active")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks