Home > database >  Filling data with with information from 1 of 3 cells
Filling data with with information from 1 of 3 cells

Time:10-08

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)))

  • Related