Forum Discussion
Jeffern
Nov 28, 2023Copper Contributor
Use of IF
=IF(B9=0;0;IF(B9='B3'='B2';IF(B9='B4'='B3))) I get error messages If a field='B3', I want to replace it with 'B2', if a field ='B4', I want to replace it with'B3*The fields are either blank(emty) =...
Jeffern
Dec 05, 2023Copper Contributor
Hans,
I used the Replace dialog. It worked just fine, and it saved me a lot of time.
I used the Replace dialog. It worked just fine, and it saved me a lot of time.
HansVogelaar
Dec 05, 2023MVP
Good to hear that. Thanks for the feedback.