Forum Discussion
Excel 2021: Replace value in one cell based on the values of two cells (that cell and one other)
Greetings: I am using Excel to normalize some foreign-language bank data for my taxes. (Excel, and Notepad++ are excellent tools for data-conversion tasks!) Given the following data truth table ...
This cannot be done with a formula in column A.
One option would be to return the desired values in a third column, for example in column C.
In C1:
=IF(OR(A1<>"", B1=""), A1, "XFR")
To change the values in column A itself would require VBA.