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) =...
A formula in B9 cannot refer to B9 - that causes a circular reference, as I mentioned that before.
Why don't you use the Replace suggestion that I mentioned in a previous reply:
"You could use the Replace dialog (Ctrl+H).
Select the range.
First, enter B3 in the 'Find what' box and B2 in the 'Replace with' box, then click 'Replace All'.
Next, enter B4 in the 'Find what' box and B3 in the 'Replace with' box, then click 'Replace All'.
Done!"
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!
Good to hear that. Thanks for the feedback.
- Hans,
I used the Replace dialog. It worked just fine, and it saved me a lot of time.