Excel if function - multiple clauses, one target cell

[Elegia]

Hi!

I am not very good at describing this problem, but I hope this clears it - and hopefully someone knows the answer! My problem is as follows:
I would like excel to check 3 cells, for instance:
x1: talent
x2: motivation
x3: innovation

Then I want excel to write something according to them in one cell, the cell Y. For instance:
if x1 > 10 write "got talent" then if x 2 > 20 "got motivation" then if x3 > 15 write "got innovation"
so the result could look like "got talent, got motivation, got innovation" all in one cell or simplu "got talent". It is easy to make excel write something in one cell, but how to make it evaluate multiple clauses (without AND function?).

Thanks in advance!

 

[Sektor]

=IF(A1="talent,","got talent","")&IF(A2="motivation","got motivation,","")&IF(A3="innovation","got innovation","")

 

[Ruddles]

...how to make it evaluate multiple clauses (without AND function?)

Why must we not use the AND function?

 

[Elegia]

Maybe I could have been more clear about this:

lets say there are 10 things to consider and evaluate:
then the combinatory tree is quite huge for instance:
1 - - - - - 7 8 9 10
1 - 3 - - - - - - 10

therefore making a specific if/and clause for each specific case is not possible. It would be easier if the excel could just check does this meet the requirement: if not do not write anything, if it does then write something and do the same 10 (or x) times over in one cell.

 

[Ruddles]

Understood. So has Sektor's suggestion done the job?

 

[Jonmo1]

Try a lookup

=LOOKUP(X1,{10,15,20},{"got talent","got innovation","got motivation"})