I'm having difficulty with constructing a proper function. My data looks like this:
A B C
1 Place Publisher [function/output goes here]
I'd like to produce the following output in C1:
(Place: Publisher)
However, not every entry will have place or publisher. So, in those cases I'd like:
(Place)
(Publisher)
[blank if there is neither]
I know how to create simple IF True or False arguments, and how to do AND and OR ones. Also, I know how to handle ISBLANK arguments. But still I'm failing to be able to string things together correctly.
Can anyone help with this?
Much thanks,
John
Bookmarks