Combining columns with If

[Usercode]

I have a range of columns (A1,B1,C1,D1). These columns have values from 1 to 20.
I have a formula in F1 like this:

=if($A1>7,"U",if($B1>7,"X",If($C1>7,"Y",if($D1>7,"Z",""))))

This formula puts the value of U,X,Y and Z if any of these cells (A1,B1,C1 or D1) is bigger than 7.

but it can't handle if there are two cells bigger than >7.

What should I add to this formula, if there are two numbers bigger than 7. So the end result will be a pair of U,X,Y or Z (comma separated).

Thanks.

 

[Usercode]

Thanks, Peter. I'll use it.

 

[Peter_SSs]

Glad to help.