Replacing contents of one cell with that of another in the same row
Is there a way, via a formula, to replace the contents of one cell with the contents of another cell in the same row, only if the second cell is not blank?
I have a credit column (CC) and a partial credit column (PCC). If there's an entry in PCC, I want that value to replace the value in CC.
Help Article Resources
Check out the Formula Handbook template!