Urgent formula help

[meganpayne156]

i need help creating a formula:

if i enter new text into column C i need column D to pick up that data

but if column c does not contain new data i need column d to pick up data from column B

[#2]

#please help

[#3 · Accepted solution]

@meganpayne156 

In D1

=IF(C1="", B1, C1)

[#4]

Thank you so much! I've just used it now!

[#5]

@meganpayne156 , glad it helped