Hey guys,

I think this is gonna be easy but I cannot seem to figure it out...
I have the following headings:

Own Client None

I have handballed data into each column leaving blank those without. So it
now looks like this:

Own Client None
Yes
Yes
Yes

What I need is a formula at the side of each row saying due to the answers
the result is either "Own" "Client" or "None".

I was thinking of using an IF forumla but that does not have enough variables.
Would it help if I changed the Yes answers to numbers (say 1 for Yes 0 for
No)?

Bit of a head scratcher...