0

I would like to merge the contents of three columns into a single column. I need to use a nested if formula as the columns take precedence over each other. Example column A1 may or may not have data. If A1 does have data then use A1 data regardless of what is in B1, or C1. If Col A1 is empty use B1 value, if B1 is also empty use C1…. Any ideas?

Improve this question

1 Answer 1

Reset to default
0

=IF(A1<>"",A1,IF(B1<>"",B1,C1))

Improve this answer
2

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .