I hope I can explain sufficiently for someone to understand and be able to help, I have 27000 records to update into one column.
I'm hoping to use a formula to fill column D with data from column A but if that cell is blank use data from column B and again if that column is blank use data column c.
]: https://i.stack.imgur.com/DTwI7.png
CodePudding user response:
May be like this in your cell D2 =IF(A2<>"", A2, IF(A2="", B2, Value(C2)))
CodePudding user response:
Try this : =IF(A1<>"",A1, IF(B1<>"",B1,IF(C1="","",C1)))