I have a sheet where either cells d1, e1 or f1 can contain a text only input. How do I return this text input to a1? (If d1 has a text input, the other two will be blank and so on)
Thanks
I have a sheet where either cells d1, e1 or f1 can contain a text only input. How do I return this text input to a1? (If d1 has a text input, the other two will be blank and so on)
Thanks
Hi
=IF(D1<>"",D1,IF(E1<>"",E1,F1))
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks