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, I will try again, see attachment. You mentioned in an earlier post:"return the desired values in another range, not in the same range", is this the problem in this case?
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!"
Jeffern wrote:
I understand a formula in B9 causes a circular reference, but where could I put it? Could be useful to know for similar use later.See the attached version.
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. - I understand a formula in B9 causes a circular reference, but where could I put it? Could be useful to know for similar use later.
- 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!