Forum Discussion
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) =...
Hans, yes, I believe the Replace option is simpler, I think that I inadvertently sent you the whole workbook, instead of one part of it. No problem!
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.
Good to hear that. Thanks for the feedback.
